Adding Minutes to a Time value

Brian McElligott

I am creating an event sheet, with time information as follows:

Setup Time Needed - values will be in 30 minute increments (30 minutes, 1 hour, 1.5 hours, 2 hours)

Requested Start Time - values will be in 30 minute increments starting at 8:00 AM to 9:00 PM

Requested End Time - values will be in 30 minute increments starting at 8:00 AM to 9:00 PM

Breakdown Time Needed - values will be in 30 minute increments (30 minutes, 1 hour, 1.5 hours, 2 hours)

I have used the TIME formula to translate the dropdown options of Requested Start Time and Requested End Time to time values.

I will need to do an if statement to add either 30 minutes, 60 minutes, 90 minutes or 120 minutes to the Requested Start Time and the Requested End Time time values to calculate an overall event time (Setup Time Needed + Requested Start Time + Requested End Time + Breakdown Time Needed).

First Step: How do I had 30 minutes to a start time, say 8:00 AM for example?

Example: The Total Event Time should be 7 hours (6 hours from Requested Start Time to Requested End Time, plus the extra hour (30 minutes Setup Time Needed and 30 minutes Breakdown Time Needed).

Paul Newcome

What are the exact options for setup and breakdown? Is it "30 Minutes", "1 Hour", etc., or is it "30 Minutes", "60 Minutes", etc.?

Brian McElligott

Hi Paul,

The drop down options for setup and breakdown are as follows:

30 Minutes
1 Hour
1.5 Hours
2 Hours

I had planned to use a nested if statement to evaluate these options into total minutes to aid in the time calculations if that would be helpful:

30 minutes
60 minutes
90 Minutes
120 Minutes

Paul Newcome

You can use the TIME function with a nested IF.

=TIME([Requested End Time]@row) - TIME([Requested Start Time]@row) + nested_IF_outputting_leading_minutes + nested_IF_outputing_following_minutes