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 |
=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 . |
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 |
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. |
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 . |
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 . . |
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 . . . |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com