Adding Time

ads_1471

New Member
Joined
Apr 19, 2016
Messages
37
Hi All

So I know on adding time formats in excel. However if I have one cell which is empty I still want to return the one cell which has the time in.

Example
A1 - 13:00 A2 - 5:00 so would equal - 18:00

However, if A2 is empty I still want it to return the A1 amount of 13:00

Wha would be the best if formula? thanks
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Saurabhj

Active Member
Joined
Jun 6, 2020
Messages
414
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi,
Normal + operation will perform the required ouput. No If statement is required.
 

Attachments

  • addTime.JPG
    addTime.JPG
    26 KB · Views: 4

ads_1471

New Member
Joined
Apr 19, 2016
Messages
37
Thanks for your reply. Unfortunately, it doesn't. It returns the #Value message.

This could be as I have a formula for the hours as in cels next this I input the start and end time of the shift which works out how many hours each shift is. If that makes any sense
 

Saurabhj

Active Member
Joined
Jun 6, 2020
Messages
414
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi, Kindly share your data using XL2BB tool. It would help to copy the data in my sheet.

Thanks,
Saurabh
 

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,990
Office Version
  1. 2016
Platform
  1. Windows
does this work: =IFERROR(A1+B1,A1)

I assume the problem arises because you've got a blank in the duration cell rather than nothing.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,890
Messages
5,638,857
Members
417,055
Latest member
SerenaCruz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top