Numbers timesheet code

Hi all I am having trouble with some code in numbers and have spent way too much time on this


trying to make a sheet that compares a start time to a end time to give a total for each job this is the easy part but my totals seem to have a 0 when no time is entered creating a error when adding my totals as some things are in h/m and others are just 0 because this is a spot with a formula in it it won’t let me format these 0s go time date. How do I make a 0 a blank

iPhone 14 Pro Max, iOS 17

Posted on Jun 19, 2024 6:20 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 19, 2024 10:46 PM

Hi Mesmo,


IF OR to test for blank in either D or E. If either is blank (""), then insert "0m" to keep all of F as Duration.



Formula in F2 is IF(OR(D2="",E2=""),"0m",E2−D2)


Regards,

Ian.

Similar questions

4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers timesheet code

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.