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)

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

"Gavton" wrote in message
...
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)