Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can Excel really deal with elapsed time?
While I can get Excel to format a cell with elapsed time (all I need it
0:00:00 to 2:59:59) I cannot get Excel to work with elapsed time. Excel keeps lapsing into treating it as clock time. When I type in 0:29:19 into a cell formatted as h:mm:ss it displays 0:29:19 so far so good. But in the function editing box it shows 12:29:19 AM and if I dbl click on the cell to edit it it transforms from 0:29:19 to 12:29:19 AM. I don't want to think about these times are midnight and some offset I want to treat them as they are, some number of seconds displayed as hours, minutes and seconds. I want to enter them that way as well. All this is for cataloging and organizing number from a timeline (video). Is there some way of convincing Excel that I am dealing with elapsed time as opposed to clock time? thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can Excel really deal with elapsed time?
Excel will do the calculations quite happily as it is. If you are dealing
with elapsed time, then you probably ought to format as [h]:mm:ss, rather than h:mm:ss (so that it will display with times beyond 24 hours). If you are particularly upset by what it is displaying in the formula bar, change your windows regional preferences to 24 hour clock and that will get rid of the AM/PM which is worrying you. -- David Biddulph "daudioguy" wrote in message ... While I can get Excel to format a cell with elapsed time (all I need it 0:00:00 to 2:59:59) I cannot get Excel to work with elapsed time. Excel keeps lapsing into treating it as clock time. When I type in 0:29:19 into a cell formatted as h:mm:ss it displays 0:29:19 so far so good. But in the function editing box it shows 12:29:19 AM and if I dbl click on the cell to edit it it transforms from 0:29:19 to 12:29:19 AM. I don't want to think about these times are midnight and some offset I want to treat them as they are, some number of seconds displayed as hours, minutes and seconds. I want to enter them that way as well. All this is for cataloging and organizing number from a timeline (video). Is there some way of convincing Excel that I am dealing with elapsed time as opposed to clock time? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Elapsed time | Excel Discussion (Misc queries) | |||
EXCEL 2003 Dates & elapsed time | Excel Discussion (Misc queries) | |||
Need Elapsed Time Help | Excel Worksheet Functions | |||
elapsed time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) |