Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello I would like to know if the following conversion is possible in excel in cell 1 I have date and time information currently formatted from the cell format menu as (dd/mm/yy hh/mm) in cell 2 I have the number of minutes that a process will take - this number is usually around 2,000 - 3,000 minutes in cell 3 is it possible to display the completion date and time of the process?
Solved by S. J. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/09/2018 - 08:56
HI, Welcome to Excel chat.
User 17/09/2018 - 08:56
hi
Excelchat Expert 17/09/2018 - 08:57
You want to calculate the completion date and time based on original time and minutes operated?
Excelchat Expert 17/09/2018 - 08:57
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 17/09/2018 - 08:58
yes
Excelchat Expert 17/09/2018 - 08:58
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 17/09/2018 - 08:58
Please fill the sample info in the preview.
User 17/09/2018 - 08:59
if it is easier to add extra cells I am happy with this
Excelchat Expert 17/09/2018 - 08:59
Ok. Thanks for the information. I am going to create formula for B3 cell.
User 17/09/2018 - 09:00
do you need me to do anything?
Excelchat Expert 17/09/2018 - 09:01
No. I am working on the formula. Please give me few minutes, while working on.
User 17/09/2018 - 09:02
if it would make it easier cell B1 does not have to be formatted in this way. it could be broken into two cells if it would help.
User 17/09/2018 - 09:02
I simply need the input and output information in some format
Excelchat Expert 17/09/2018 - 09:02
Basically, B1 is not in the right time and date format.
User 17/09/2018 - 09:03
could you please show me a better way?
Excelchat Expert 17/09/2018 - 09:03
Can you please copy it from the original? or i will reenter the date and time.
User 17/09/2018 - 09:04
you can re enter - any time or date is fine
Excelchat Expert 17/09/2018 - 09:04
Ok.
Excelchat Expert 17/09/2018 - 09:05
=B1+B2/1440
User 17/09/2018 - 09:06
Have you changed the formatting?
User 17/09/2018 - 09:06
thank you
Excelchat Expert 17/09/2018 - 09:06
The format is not right. So, i have reentered the date and time.
Excelchat Expert 17/09/2018 - 09:06
Google sheet picks as mm/dd/yyyy hh:,mm
User 17/09/2018 - 09:07
ok i see it is in american format
User 17/09/2018 - 09:07
is excel the same?
Excelchat Expert 17/09/2018 - 09:07
So, i have entered in the same format.
Excelchat Expert 17/09/2018 - 09:07
When you download to your local, it converts to your format automatically.
User 17/09/2018 - 09:07
thanks this is a big help
User 17/09/2018 - 09:08
I will just quickly test the file on excel
Excelchat Expert 17/09/2018 - 09:08
But, i have changed the format of the cell.
Excelchat Expert 17/09/2018 - 09:08
Whether the formula to add minutes is very simple as shown.
User 17/09/2018 - 09:08
yes - thank you. It works
Excelchat Expert 17/09/2018 - 09:08
Great to hear.
User 17/09/2018 - 09:08
thanks for your help

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.