Hi all,
I am currently working on a rota.
At present a formula calculates how long a particular shift is in hours & minutes. However if the person is on holiday, sick etc the formula returns #VALUE. I understand why but is there a way for the formula to not bother trying to calculate the shift length if a non-numeric value is entered?
Last edited by lukela85; 10-24-2013 at 07:23 AM.
Post your formula here (or, better still, a sample workbook).
Pete
Replace the cell reference as necessary, and "Stuff" with your existing formula.Originally Posted by lukela85
Formula:
=if(isnumber(A1),"Stuff","")
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly, formula works perfectly.
Marked as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
lukela85 
Register To Reply
Bookmarks