I need an Excel formula for converting hours to days?

[Guest]

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

 

[Guest]

Not sure if I understand the question, but try =YourFormula/24 and format the
cell to be a number with zero digits.

 

[David Biddulph]

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.

 

[Guest]

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

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

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

 

[David Biddulph]

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

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

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

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