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