I need a formula PLEASE HELP

  • Thread starter Thread starter Excel ??
  • Start date Start date
E

Excel ??

-- 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
 
Hi Try this

0.013888888888889 = 20 minutes
08:00 + 0.013888888888889 = 08:20

Regards
Rajesh Mehmi
(e-mail address removed)
 
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.
 
didn't work
--
2


Shane Devenshire said:
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
Click to expand...
 
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>>


didn't work
 
Back
Top