So it would be =B1-A1[h]:mm


"Bob Phillips" wrote in message
...
It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Thanks Bob, I tried to put formatting in but I kept getting an error
because I really don't know where to put the parentheses so I tried
Rick's solution and it worked!


"Bob Phillips" wrote in message
...
=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"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