hi
don't put the fomating in the formula.
right click the desired cell, choose format cell.
click the number tab. click custom. enter the custom format there.
once entered, you can format other cells by selecting the custom format
Regards
FSt1

"Linda RQ" wrote:

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