Trying to remove #NUM error from cell but is not working
Formula:
Please Login or Register to view this content.
This is what i'm using to try to calculate the hours between 2 times and also leave it blank if some of the data is missing
It isnt working though (the leaving it blank part) what am i doing wrong?
Hi,
Wrap the =HOUR() function in the =IFERROR() function rather than the other way around.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I'm such an idiot!
Thanks, Done, Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks