Time formula

[Arm15]

Good day, can anyone please help me.
I found a formula to calculate working hours. what can i use to indicate that 8 hours equals 1 working day?

Start date End date Total hours
28/10/13 8:00 30/10/13 8:00 18.00

The 18.00 should display 2 day 00 hrs

Thank you

 

[Xiq]

Hi Arm,

Try this formula:

=INT(B1-A1)+(B1-A1-INT(B1-A1))/(1/3)

Where A1 = Start Date
And B1 = End Date

 

[Arm15]

Thank you, but this does not exclude weekends and after hours. any suggestions?

 

[Arm15]

The formula Iused ro calulate the days are:
=9*(NETWORKDAYS(A12,B12)-1)-24*((MOD(A12,1)-MOD(B12,1)))

 

[Xiq]

How about this then:

=NETWORKDAYS(A1,B1)+(B1-A1-INT(B1-A1))/(1/3)

 

[Debraj]

Hi Arm15!
I guess.. you have already the formula for "NetWorkHour" which is giving you answer as "18:00"
SO overlooking, how you are geting 18:00, just instead of "18:00", paste your formula,

and jto convert 18:00 as 2, use below formula.
=ROUND(DOLLARDE("18:00",375),2)& " Days"

 

[SirJB7]

@Debraj(ex-Roy)
Hi!
Nice trick that of using DOLLARDE function, one very infrequently used.
Regards!

 

[SirJB7]

Hi, Arm15!
Another formula:
=ENTERO(C1/9)&" day "&RESIDUO(C1;9)&" hrs" -----> in english: =INT(C1/9)&" day "&MOD(C1,9)&" hrs"
where C1 is your formula using NETWORKDAYS.
Regards!