View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gavton Gavton is offline
external usenet poster
 
Posts: 1
Default set XL formula to add mins to a time i.e add 45mins to 8am to get

I am trying to set up an interview schedule sheet in Excel, so that I can
just enter the minutes and it will automatically fill in the times i.e if I
enter the times of:
Interview duration = 45 mins
Interview Start time = 8:00 am

How do I get the sheet to add the 10 minutes to the start time of 8:00 am so
I get the result of as follows which looks like this is a spreadsheet

Interview duration
45 mins (to manually enter)

Interview Start Interview end
8:00 (to manually enter) 8:45 (auto calc)