Decimal Time

[Steved]

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

 

[Jason Morin]

=A1+TIME(,8,)
=A1+8/24/60
=A1+"00:08"

All of these will add 8 min.

HTH
Jason
Atlanta, GA

 

[JE McGimpsey]

one way:

=HOUR(TIME(A1,MOD(A1,1)*100+8,0)) +
MINUTE(TIME(0,MOD(A1,1)*100+8,0))/100

 

[JE McGimpsey]

But none of them return 8.33 when A1 = 8.25.

 

[Steved]

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


.

 

[Steved]

Hello Jason From Steved

Your formulas were adding 1 minute
using your formula 8.00 would become 8.01.

What Shoud I have formatted the cell to get your formula
to work.

Thankyou.

 

[Jason Morin]

I assumed your values were time values, formatted as
[h].mm. When A1 = 8.25 (or the numerical value 0.350694),
all 3 formulas return 8.33.

If you simply have 8.25 keyed into a cell, then this
would actually represent 8 days, 6 hours. In this case,
use J.E.'s formula.

Sorry for the confusion.

Jason