Thread: Decimal Time
View Single Post
  #6   Report Post  
Steved
 
Posts: n/a
Default

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.


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

All of these will add 8 min.

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

.