Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() How to get time difference in hours and fractions of hours? example 3 columns in a spread sheet Col A and B formated as "Time" Col C formatted as Custom "h:mm" produces result 0:20 in example below how to format so as to produce result 0.3333? I tried formatting as "h" but it then produces 0 formatting as 0.00 produces 0.01 - no clue how it comes up with that one? Col A Col B Col C Start Time End Time Elapsed 2:50 PM 3:10 PM = B-A thanks mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtract times? | Excel Discussion (Misc queries) | |||
subtract times with a negative result | Excel Discussion (Misc queries) | |||
How to subtract[difference] in TIMES?? | Excel Worksheet Functions | |||
How can I subtract and enter times in my charts? | Charts and Charting in Excel | |||
excel should allow to add and subtract times | Excel Worksheet Functions |