I have a formula that works out how many hours long a shift is even if the time goes past midnight.
=IF(L4<M4,M4-L4,M4+1-L4)
The data in L4 and M4 are the starting and finishing times.
However if there is no data in the cell then it returns a result of 24:00. Is there anyway I can change the formula to produce a zero return if there is no data in the cells?
Much appreciated.
Last edited by Marvo; 12-23-2012 at 02:04 PM.
Do you mean
or shorter
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Ace_XL; 12-23-2012 at 01:46 PM.
Life's a spreadsheet, Excel!
Say thanks, Click *
That works a treat. Thank you very, very much. Merry Christmas.
Marvo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks