Forum Discussion
Formula If, Time calculations
Good morning, I have an issue with formula 'if' with time calculations. I hope somebody can help me. This is the case (see file in attachment : I know you would probably make all these cal...
Piero_VDP , below formula shall work fine for B56 cell
=IF(TIMEVALUE(N47)=$C$45,"0:00",C38+($C$26-N47))
Basically,
1) if cell format is TIME, then EXCEL recognizes cell value as "HH:MM:SS AM/PM". So even though cell value apears to eyes as "0:00" , but EXCEL interprets it as "12:00:00 AM"
2) If cell format is GENERAL or TEXT , or as in your case it is a "text" result of another formula, then EXCEL interprets text as text. But this text "0:00" is not same as time "0:00"
3) Care to learn about how TIMEVALUE function works. It converts the text time to "TIME" time.
Knowing above 3 concepts, you would understand how the solution given above works, and how you can take care about dealing with time calculations in future.
