set XL formula to add mins to a time i.e add 45mins to 8am to get

[Guest]

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)

 

[Biff]

Hi!

Try one of these::

A1 = 45
A2 = 8:00 AM

=A2+A1/1440 (format the cell as TIME)

Or:

=TIME(HOUR(A2),MINUTE(A2)+A1,0)

Note: Do not enter the duration as "xx mins", just enter the number, 45.
Entering as "xx mins" makes it a TEXT entry.

Biff