Converting total number of hours (>24 hours) into days

M

MV Rao

I have a series of cells containing time spent. When I sum them up, it is >24
hours. When I format the cell with [h]:mm, I can see the total correctly. But
I want to calculate number of days by dividing this hours by 8. How do I do
it?
 
N

Niek Otten

To get a whole number as number of hours, multiply by 24
So for workdays, divide by 8 and multiply by 24
Times in Excel are stored as fractions of a day

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a series of cells containing time spent. When I sum them up, it is >24
| hours. When I format the cell with [h]:mm, I can see the total correctly. But
| I want to calculate number of days by dividing this hours by 8. How do I do
| it?
| --
| MV Rao, VP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

years-months-days-hours 5
How do you put Days and Hours into total hours 11
Sum and average number of days and hours 4
Adding Hours 1
Adding hours and minutes 1
why is answer rounded up? 1
Display Sum of hours as an equivalent in days and hours 2
Excel Sumproduct 0

Top