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