Help with formula: IF, variable, add time into a different cell [Closed]

Report
Posts
7
Registration date
Thursday December 21, 2017
Status
Member
Last seen
January 4, 2018
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello, I found this website after bumping my head with the keyboard trying to find a solution to a question I have.
I am trying to create a spreadsheet that will allow me to add a fix amount of time to a starting time. The whole process is to determine that if given a start time of day, and a duration of a process, what would be the end time of it.

This is what I could create so far, but I don't know how to add several variables on one formula. I was able to do it per variable on separate cells, but I'd like the formula to be on one cell altogether;

A1 is the original time, B1 will be a type of 3 equipment to choose from, C1 will be either 40, 45 or 55 minutes depending on type, depending on type of equipment on B1, then D1 will add C1 and A1 and throw a sum result of those to give me the end time.
I tried =IF(B1="319",+"0:40")*IF(B1="320",+"0:45")*IF(B1="321",+"0:55") And then D1=A1+C1 but all I get is zeros and no addition is made.

Any help pointing me on the right direction would be highly appreciate it.


Thanks!

2 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
leoojeda, Good afternoon.

Suppose:

A1 --> 10:00 (Cell formated as hh:mm)
B1 --> 319

Try to use:

D1 --> (Cell formated as hh:mm)

D1 --> =A1 + IF(B1=319,"0:40",IF(B1=320,"0:45",IF(B1=321,"0:55","")))*1

Please, tell us if it worked as you want.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
7
Registration date
Thursday December 21, 2017
Status
Member
Last seen
January 4, 2018

Thank you Marcilio!

So I wont need to put anything on C1 right? this formula will add both times from A1 plus the different time depending on type directly on D1 cell, right?

How do I make the cells to show the time in minutes alone? I.E if the time is 20 over one hour, to count it as 80min?

Its finally going on the right direction, Thanks1
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
leoojeda,

"So I wont need to put anything on C1 right?"
Right!

"this formula will add both times from A1 plus the different time depending on type directly on D1 cell, right?"
Exactly!

"How do I make the cells to show the time in minutes alone?
I.E if the time is 20 over one hour, to count it as 80min? "


Format cell D1 as [mm]

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão