S
Sharon Tischner
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
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
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
Not sure if I understand the question, but try =YourFormula/24 and format the
cell to be a number with zero digits.
cell to be a number with zero digits.
D
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.
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.
S
Sharon Tischner
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
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 said: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 said: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
D
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
you want the answer in days) format the result as general or number.
--
David Biddulph
Sharon Tischner said: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 said: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 said: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