Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This isn't my data so please bear with me. I have no idea *why* things are this way, nor do I really have to understand
what the values mean, in the big picture. I just have to do some manipulation while another person is out. I've got a cell formatted as "Time", of type hh:mm:ss (at least I think that's what the 37:30:55 means) ... all of which I take to mean this is an elapsed time The value in the cell is 0:02:09, which again I take as meaning an elapsed time of 0 hours, 2 minutes, and 9 seconds. How do I convert that 0:02:09 into a *decimal* representation of the elapsed time? I want to put the decimal representation (say 2.10, representing 2 and 1/10 minutes) into another cell? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |