PDA

View Full Version : Solved: Subtracting dates/times to show number of hours?



NateW
12-03-2007, 11:54 AM
Hi, Folks...

Quick little question here - and my apologies, this doesn't even need to be in VBA, if there is a simple formula in excel to do this. What I'm trying to do is subtract one date/time from another, and to have the answer be the number of hours. For example:

September 12, 2007 13:00 - September 10, 2007 3:30 = x number of hours and minutes.

Thanks in advance for any help that you can offer!! :bow:

Bob Phillips
12-03-2007, 12:26 PM
=A1-B1

and format as [h]:mm

NateW
12-03-2007, 01:02 PM
Thanks!