Help with formula: IF, variable, add time into a different cell
Closed
leoojeda
Posts
5
Registration date
Thursday December 21, 2017
Status
Member
Last seen
January 4, 2018
-
Dec 21, 2017 at 07:46 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 21, 2017 at 12:38 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 21, 2017 at 12:38 PM
Related:
- Which function will you use to enter current time in a worksheet cell?
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 21, 2017 at 09:16 AM
Dec 21, 2017 at 09:16 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 21, 2017 at 12:38 PM
Dec 21, 2017 at 12:38 PM
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
"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
Dec 21, 2017 at 12:26 PM
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