# hours into working days

#### bam12

##### Well-known Member
if i ahve 66.5 hours, what formula would i use to show it in work days
with work says being hours hours long

so that it would show 8 days 2 1/2 hours

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### jbfrank

##### Active Member
I'm not sure of the formatting of your information, but let's assume you have 66.5 in cell A1. In cell B1, enter the following =A1/8.

Right click on cell B1 and change the format to Custom. In the "Type:" field at the top, enter dd:hh:mm and click OK.

You should be left with 08:07:30, which is 8 Days, 7 hours, and 30 minutes.

#### UPN

##### Board Regular
incorrect

8 times 8 is 64

subtract from 66.5 leaves 2 1/2 hours not 7 hours .30 minutes

#### UPN

##### Board Regular
sorry about first message should have been 8 hours is a day

#### daniels012

##### Well-known Member

This should work for most total hours:
Book1
FGHI
1166.5
12
13=ROUND(F11/8,0)=MOD(F11,8)
14
158Days2.5hours
Sheet1

Michael

#### jbfrank

##### Active Member
Oops. Obviously not thinking on this one...

#### UPN

##### Board Regular

problem

Daniels012

Looks like there is a problem with formula, if you put 100.5 hours in here it should be 12 days 4.5 hours

it is coming up 13 days 4.5 hours

bump

#### daniels012

##### Well-known Member

Try!
=INT(F11/8) 'For the days

Michael

Replies
3
Views
122
Replies
26
Views
3K
Replies
1
Views
68
Replies
10
Views
146
Replies
2
Views
136