Date & Time Minus Date & Time

**Dave69rock** · 09-09-2009, 10:20 PM

Hi

In B7 i have 10/09/2009 19:30:00
In C7 i have 11/09/2009 21:30:00

What i want is C7-B7 and give the number of hours in between which should be 26 hours

I've used this:

Please Login or Register  to view this content.

But i get 01/01/1900 02:00

Hope you can help
Dave

**Paul** · 09-09-2009, 10:27 PM

Hi Dave,

Just use the formula

=C7-B7

and format that cell using a Custom format of: [h]

**teylyn** · 09-09-2009, 10:29 PM

Hi,
try this

=C7-B7

format as [h]:mm:ss

hth

**Dave69rock** · 09-09-2009, 10:37 PM

Thanks for the quick reply

I've already tried that and i get 2 as the value

Dave

**Paul** · 09-09-2009, 10:39 PM

Are you 100% absolutely certain you set the custom format exactly as we show it? Including the brackets around the h? It should look exactly like:

[h]

in the custom format textbox.