this may be really simple but having had several attempts I am hoping someone will be able to help.
I am trying to work out a time balance. I need a formula to work out what a negative time plus a positive time would be e.g. -13:03 + 2:54 = -10:25 but I just keep getting #Value!
I also need the final answer to be converted to minutes so if I can do this at the same time that would be great.
Again, I cannot figure out how to display the negative hours into minutes.
I have the 1904 data system ticked
Thanks in advance for any help