Thankyou J E
-----Original Message-----
one way:
=HOUR(TIME(A1,MOD(A1,1)*100+8,0)) +
MINUTE(TIME(0,MOD(A1,1)*100+8,0))/100
In article ,
"Steved" wrote:
Hello from Steved
I would like a formula please to add 8 minutes to below
please they are in Decimal.
8.25 will be 8.33
11.57 will be 12.05
Thankyou in Advance
.
|