I need a formula PLEASE HELP

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
 
R

Rajesh Mehmi

Hi Try this

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

Regards
Rajesh Mehmi
(e-mail address removed)
 
S

Shane Devenshire

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.
 
E

Excel ??

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
 
R

Rich/rerat

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top