adding time

[Steved]

Hello From Steved

705,1200,1430,1900,30

The above is time without ":"

What I would like is a formula to

Sign on,Sign-off Sign on,Sign-off MealBreak

705 - 1200 + 1430 - 1900 - 30 to equal 8.55

Thankyou.

 

[Peo Sjoblom]

One way

=MOD((INT(D1/100)+MOD(D1,100)/60)/24-(INT(A1/100)+MOD(A1,100)/60)/24-((INT(C
1/100)+MOD(C1,100)/60)/24-(INT(B1/100)+MOD(B1,100)/60)/24),1)-TIME(,E1,)

assuming that the values are in cells A1:E1

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Steved]

Thankyou Peo

-----Original Message-----
One way

=MOD((INT(D1/100)+MOD(D1,100)/60)/24-(INT(A1/100)+MOD (A1,100)/60)/24-((INT(C
(B1,100)/60)/24),1)-TIME(,E1,)

assuming that the values are in cells A1:E1

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)






.