Whatever hours you've got formatted as [h]:mm:ss, add them up, and then (if
you want the answer in days) format the result as general or number.
--
David Biddulph

"Sharon Tischner" wrote in
message ...
I need the total number of hours to convert to days. This is for a
reimbursement log sheet for a class I am taking. The result needs to
calculate the total number of hours I will be entitled too when my class
is
done.
thx
st

"David Biddulph" wrote:

If the cell in the A3 column is intended to be the total of the same
row's
A1 and A2 cells, then formatting A3 as [h]:mm.ss will change it from
4:15:00
PM to 40:15:00.
I can't see where your 2:50:00 AM total comes from.

You asked, in your subject line though not in the body of your message,
about converting hours to days. If you want your 40:15:00 displayed as
days, then merely format it as General or Number.
--
David Biddulph

"Sharon Tischner" <Sharon wrote in
message ...
A1 A2 A3
18:15:00 22:00:00 4:15:00 PM
18:15:00 22:05:00 4:20:00 PM
total 2:50:00 AM