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.