Calculating hours that have passed from one date to another

[wetbean]

Does anyone know how to work out how many hours have passed from a start date to an end date?

I.e Start Date/Time: 05/10/2011 10:00 End Date/Time: 06/10/11 12:00 (26:00 hours)

I tried subtracting one from the other with the date and time format (custom dd/mm/yyyy hh:mm) but it can never deal with anything over 24 hours.

Sheet attached with an example highlighted. Column E is start date/time; column G is end date/time; Column I is, at the moment, simply G-E.

Many thanks and kind regards,

Zak

[daddylonglegs]

If you want to see total hours use a custom format of

[h]:mm

Note square brackets

That will then display as 321:01 in I7

or to show days then use this formula in I2 copied down

=INT(G2-E2)&" days "&TEXT(G2-E2,"h:mm")

then I7 will show 13 days 9:01

[wetbean]

Thanks for the help.

Much appreciated