View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajesh Mehmi Rajesh Mehmi is offline
external usenet poster
 
Posts: 26
Default 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