You Da Man Rick! Thanks!


"Rick Rothstein" wrote in message
...
If you need the actual decimal hours (13.666...), then try this formula...

=24*(H2-G2)

--
Rick (MVP - Excel)


"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda