| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert time listed in hours(e.g. 170:41:19) to seconds?
I have a data cell that lists the sum of times, but it displays in a format
with colons in it. I want to convert that data to a SINGLE NUMBER. For example, I would like to convert 170:41:19 to 614479 (the number of seconds in 170 hours, 41 minutes and 19 seconds). I have more than 7000 of these cells so I cannot do it manually. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert time listed in hours(e.g. 170:41:19) to seconds?
I multiplied the time by 24 and then multiplied that by 3600.
Example: if 170:41:19 is in A1, then in B1: =(A1*24)*3600 = 614479. Make sure B1 is formatted as numbers, not time. -- Brevity is the soul of wit. "Red Data Man" wrote: I have a data cell that lists the sum of times, but it displays in a format with colons in it. I want to convert that data to a SINGLE NUMBER. For example, I would like to convert 170:41:19 to 614479 (the number of seconds in 170 hours, 41 minutes and 19 seconds). I have more than 7000 of these cells so I cannot do it manually. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert time listed in hours(e.g. 170:41:19) to seconds?
hi,
=((day(a1)*24+hour(a1))*3600)+(minute(a1)*60)+seco nd(a1) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Red Data Man" escreveu: I have a data cell that lists the sum of times, but it displays in a format with colons in it. I want to convert that data to a SINGLE NUMBER. For example, I would like to convert 170:41:19 to 614479 (the number of seconds in 170 hours, 41 minutes and 19 seconds). I have more than 7000 of these cells so I cannot do it manually. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| The shortcut to enter time in excel should include seconds. | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Hybrid Mode
