asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,286
- Office Version
- 2013
- Platform
- Windows
Good Day,
With below formula I have two questions.
1) Is there any way to add up to formula which will show as in hr & min text like 12:00 / 13:25 = 1hr. 25min.
2) If there is no values on target cells possible to keep the formulated cells blank not 0:00
Many Thanks
With below formula I have two questions.
1) Is there any way to add up to formula which will show as in hr & min text like 12:00 / 13:25 = 1hr. 25min.
2) If there is no values on target cells possible to keep the formulated cells blank not 0:00
Many Thanks
Code:
=IF(F3>E3,F3-E3,1-E3+F3)
