Count hours between dates and times given

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

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

3-Feb-2004 14:20 to 4-Feb-2004 15:30 ?
 
Hi
just subtract them. e.g.
B1 - A1
and format the result with the custom format [hh]:mm
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top