Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
Hey Bob...thats a real one...Ill standby in this thread also...we wait for
the most helpful answer....hope u dont mind... "bob" wrote: I'd like to enter a time in hours, minutes, and seconds that is beyond the standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
format all the cells as [h]:mm:ss
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "bob" wrote in message ... I'd like to enter a time in hours, minutes, and seconds that is beyond the standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
Custom format your cells as [hh]:mm:ss
This allows "elapsed time" and can go beyond 24 hours "bob" wrote: I'd like to enter a time in hours, minutes, and seconds that is beyond the standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
Bob says...."I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)." "daddylonglegs" wrote: Custom format your cells as [hh]:mm:ss This allows "elapsed time" and can go beyond 24 hours "bob" wrote: I'd like to enter a time in hours, minutes, and seconds that is beyond the standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
That works. Thanks.
I'd also like to convert the accumulated time (e.g., 58:12:10) into total minutes as a whole number and fraction (e.g., 3492.16, which equals 58 hours times 60 minutes plus 12 minutes plus 10 seconds). Any thoughts? Thanks, Bob "romelsb" wrote: Bob says...."I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)." "daddylonglegs" wrote: Custom format your cells as [hh]:mm:ss This allows "elapsed time" and can go beyond 24 hours "bob" wrote: I'd like to enter a time in hours, minutes, and seconds that is beyond the standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
=A1*24*60
and format as number or general. -- David Biddulph "bob" wrote in message ... That works. Thanks. I'd also like to convert the accumulated time (e.g., 58:12:10) into total minutes as a whole number and fraction (e.g., 3492.16, which equals 58 hours times 60 minutes plus 12 minutes plus 10 seconds). "romelsb" wrote: Bob says...."I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)." "daddylonglegs" wrote: Custom format your cells as [hh]:mm:ss This allows "elapsed time" and can go beyond 24 hours "bob" wrote: I'd like to enter a time in hours, minutes, and seconds that is beyond the standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63). The only timestamps among Excel's format options seem to be AM and PM, which limits the time to a range of 00:00:00 through 24:00:00. I want to go higher than 24:00:00. Can anyone help? Thanks. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Time Function | Excel Worksheet Functions | |||
adding a code to calculate how much time is lost | Excel Discussion (Misc queries) | |||
Adding time | Excel Worksheet Functions | |||
what is the formula for adding up time intervals? | Excel Discussion (Misc queries) | |||
adding in time formats | Excel Discussion (Misc queries) |