I need a formula PLEASE HELP

[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

 

[Roger Govier]

see response to your posting in another group

 

[Rajesh Mehmi]

Hi Try this

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

Regards
Rajesh Mehmi
(e-mail address removed)

 

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

 

[Excel ??]

didn't work
--
2

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 ??]

it didn't work
--
2

see response to your posting in another group

 

[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