I need a formula PLEASE HELP
-- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
I need a formula PLEASE HELP
see response to your posting in another group
-- Regards Roger Govier "Excel ??" wrote in message ... -- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
I need a formula PLEASE HELP
Hi Try this
0.013888888888889 = 20 minutes 08:00 + 0.013888888888889 = 08:20 Regards Rajesh Mehmi "Excel ??" wrote in message ... -- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
I need a formula PLEASE HELP
Hi,
If you enter the first time in A1 as a legal Excel time then in A2 enter =A1+1/72 and copy it down as far as you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Excel ??" wrote: -- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
I need a formula PLEASE HELP
didn't work
-- 2 "Shane Devenshire" wrote: Hi, If you enter the first time in A1 as a legal Excel time then in A2 enter =A1+1/72 and copy it down as far as you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Excel ??" wrote: -- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
I need a formula PLEASE HELP
it didn't work
-- 2 "Roger Govier" wrote: see response to your posting in another group -- Regards Roger Govier "Excel ??" wrote in message ... -- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
I need a formula PLEASE HELP
Excel ??,
Make sure you format the cell or column as time: hh:mm am/pm -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule <<Previous Text Snipped to Save Bandwidth When Appropriate "Excel ??" wrote in message ... didn't work -- 2 "Shane Devenshire" wrote: Hi, If you enter the first time in A1 as a legal Excel time then in A2 enter =A1+1/72 and copy it down as far as you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Excel ??" wrote: -- Can someone give me a formula with a 20 minute slot times like a meeting starts at 8:00AM second 8:20AM followed by 20 minutes after...I need this formula to calculate the 20 minute time frame!! thank you thank you thank you -- 2 |
All times are GMT +1. The time now is 07:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com