I need an Excel formula for converting hours to days?
 

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

I need an Excel formula for converting hours to days?
 

Not sure if I understand the question, but try =YourFormula/24 and format the
cell to be a number with zero digits.
--
~Anne Troy
www.OfficeArticles.com


"Sharon Tischner" wrote:

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

I need an Excel formula for converting hours to days?
 

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

I need an Excel formula for converting hours to days?
 

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

I need an Excel formula for converting hours to days?
 

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