Count hours between dates and times given

J

Joyce

Hello

Is there a formula that can calculate the total of hours between

3-Feb-2004 14:20 to 4-Feb-2004 15:30 ?
 
F

Frank Kabel

Hi
just subtract them. e.g.
B1 - A1
and format the result with the custom format [hh]:mm
 
N

Norman Harker

Hi Joyce!

If your dates and times are in A1 and B1 in forms recognised as dates
and times by Excel:

=(B1-A1)*24

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

Joyce Oakes

Sorry I did not make myself clear,

A1 = 3-FEb-2004
B1 = 14:30

C1 = 4-FEb-2004
D1 = 15:30

In E1 I want to know the difference in hours.

Thanks
Joyce
 
N

Norman Harker

Hi Joyce!

Try:
=(C1+D1)-(A1+B1)
Format [hh]:mm

or:
=((C1+D1)-(A1+B1))*24
Format General

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top