Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Decimal Time
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 |
#2
|
|||
|
|||
=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 . |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
But none of them return 8.33 when A1 = 8.25.
In article , "Jason Morin" wrote: =A1+TIME(,8,) =A1+8/24/60 =A1+"00:08" All of these will add 8 min. |
#5
|
|||
|
|||
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 . |
#6
|
|||
|
|||
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 . . |
#7
|
|||
|
|||
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 -----Original Message----- 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 . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statement - in time not decimal minutes | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions | |||
Subtract Decimal time | Excel Worksheet Functions | |||
decimal time subtraction please. | Excel Worksheet Functions |