Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Time Format

0

I have 4 column

1st Start Time  2nd End Time 3rd Break Time  4th Calculated Time

I need to calculate if column (1) or (2) both have 0:00 then calculated time should be blank instead of zero, otherwise it will calculate time from start and stop after subtracting breaktime.

Answer
Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1989) Jun 22, '17 at 4:49 am
Add to Discussion

Answers

0

Create an IF formula.    =if(and(Col1=0:00,Col2=0:00),"",other formula). If you show example it could be easier to solve.

Discuss

Discussion

Dear  queue &  cappymer1
i am using office 2013 and given formula is not working for me.
Kalim Jun 21, '17 at 7:50 am
please note that colum (1), (2) & (3) are in time format h:mm
Kalim Jun 21, '17 at 8:08 am
Add to Discussion
0

Hi and welcome! :)

Use queue's formula and then add a simple formula into the other formula part of it.

See if this helps...

=if(and(A3="0:00",B3="0:00"),"",B3-A3-C3)

Update

I put quotes around the zeros and it works now.

Alternatively, this should work...

=IF(AND(A3=0,B3=0),"",B3-A3-C3)
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login