Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding Time Format
you need to do something like this
A1: 8:30 AM A2: 12:00 PM A3: =(A2-A1)*24 and then format A3 as a number. "jtinne" wrote: I am adding time for a day and would like the total to be returned in a different format. If I needed the time between 8:30am and 12:00pm added up it displays 3:30 as my total. How do I have it display 3.5 as the total? Currently the total cell is formatted [hh]:mm. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutom Time Format | Excel Discussion (Misc queries) | |||
Custom Format time to arc | Excel Discussion (Misc queries) | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
How to format elapsed time for swimming scores | Charts and Charting in Excel | |||
Subtracting time in date format | Excel Worksheet Functions |