Thanks FSt1, I couldn't figure out how to put the formatting into the
formula/fx


Linda

"FSt1" wrote in message
...
hi
i think days360 counts days not hours. if your times are that close, you
might be better off just subtracting H2 from G2 and formating the results
as
time ie [hh]:mm:ss. the brackets around the hh will cause the hours to
accumilate and not roll over every 24 hours.

Regards
FSt1

"Linda RQ" wrote:

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