Time and Minute formulas
Dear All,
I want to use formula for below situtation:- Cell value A1 120 Minutes B1 09:00 AM (Start Time) C1 (should be 10:00 am+120 Minutes = 11:00 AM) |
Time and Minute formulas
=B1+(A1/60/24)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Prem Soni" wrote in message ... Dear All, I want to use formula for below situtation:- Cell value A1 120 Minutes B1 09:00 AM (Start Time) C1 (should be 10:00 am+120 Minutes = 11:00 AM) |
Time and Minute formulas
Yes it working later on i have lot of other query and will ask u the same..
Thanks a lot, Bob "Bob Phillips" wrote: =B1+(A1/60/24) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Prem Soni" wrote in message ... Dear All, I want to use formula for below situtation:- Cell value A1 120 Minutes B1 09:00 AM (Start Time) C1 (should be 10:00 am+120 Minutes = 11:00 AM) |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com