| 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? |
| 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) | |||
Threaded Mode
