8 replies
by dgh Accepted solution
by purpleskys Accepted solution
by Member 25348569 Accepted solution
by who am i really Accepted solution
after formatting the cells to Time use the serial number equivalents
to have date / times enter the correct time
the format is #####.#####
where
#####. is the date portion and
.##### is the time portion
ie.
18/02/1982 12:00:00 = 30000.5
18/02/1982 13:12:00 = 30000.55
18/02/1982 13:19:12 = 30000.555
18/02/1982 23:59:59 = 30000.99999
to skip the date part just use the numbers after the .
ie.
to get 12:00:00 with no specific date assigned use .5
00:00:00 (midnight) = 0
all other time numbers are lower than 1
ie.
23:59:59 = .99999
by santeewelding Accepted solution
by who am i really Accepted solution
10[b]:[/b]21
12[b]:[/b]15
etc.
in 12 hour clock you append AM / PM
in 24 hour you start at 0 add leading the zero and increment past 12 to 23
00[b]:[/b]00
01[b]:[/b]00
02[b]:[/b]00
03[b]:[/b]00
04[b]:[/b]00
05[b]:[/b]00
06[b]:[/b]00
07[b]:[/b]00
08[b]:[/b]00
09[b]:[/b]00
10[b]:[/b]00
11[b]:[/b]00
12[b]:[/b]00
13[b]:[/b]00
14[b]:[/b]00
15[b]:[/b]00
16[b]:[/b]00
17[b]:[/b]00
18[b]:[/b]00
19[b]:[/b]00
20[b]:[/b]00
21[b]:[/b]00
22[b]:[/b]00
23[b]:[/b]00
good luck getting excel to display an analog dial clock in a cell
by Member 25348569 Accepted solution
by who am i really Accepted solution
to avoid typing the [b]:[/b]
you have to type the serial equivalents
1645 = 02/07/1904 00:00:00
.1645 = 03:56:53
This discussion is closed to new replies.
Trending Software posts
Sort by Trending