Calculate hours between 2 dates and times

[justDave]

Hi all,

Hopefully a very simple question for you all:

I have a series of dates and times in DD/MM/YYYY HH:MM format - is there a simple way of calculating the number of hours between them? I tried just subtracting one from the other but it gave me a #VALUE! error.

Many thanks in advance

 

[dave3009]

If you just wanted to try deleting them then this might work.

=INT((A1-B1)*24)

 

[JamesW]

Hi,

Are you sure they are both DD/MM/YYYY HH:MM format? I have just tested it using:

19/04/2011 09:49 and 18/04/2011 05:44 then I did =B1-A1 and formatted as [hh]:mm and it gave me 28:05 which is correct.

 

[justDave]

You're right, there is a formatting issue somewhere in the times. I will dig into these and find out where the issue is.

Many thanks for both of your time.

 

[jasonb75]

What dates do you have in your sheet?

If you edit the dates so that both have a day not greater than 12, do you get a result then?