| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| Working Hours (formula & graph) - any elegant solution? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Excel running date formula minus weekend days | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Hybrid Mode
