View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel ??[_2_] Excel ??[_2_] is offline
external usenet poster
 
Posts: 19
Default 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