I need to subtract one date/time in cell A1 from another date/time in cell B1 and get the total HOURS as the result in cell C1. Can anyone help me???
I need to subtract one date/time in cell A1 from another date/time in cell B1 and get the total HOURS as the result in cell C1. Can anyone help me???
Try...
=(B1-A1)*24
OR
=B1-A1
...and custom format the cell as [h]
Hope this helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks