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. |
All times are GMT +1. The time now is 04:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com