Help with formula: IF, variable, add time into a different cell
Closed
leoojeda
Posts
7
Registration date
Thursday December 21, 2017
Status
Member
Last seen
January 4, 2018
-
Dec 21, 2017 at 07:46 AM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - Dec 21, 2017 at 12:38 PM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - Dec 21, 2017 at 12:38 PM
Related:
- Which function will you use to enter current time in a worksheet cell?
- Which function will you use to enter current time in a worksheet cell ✓ - Office Software Forum
- Current time by clicking comm button in excel - Excel Forum
- Activeworkbook.worksheets current worksheet ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
2 replies
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
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
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
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