Hi,
I have an issue where I'm trying to add up the time difference for negative and positive values formatted as Text.
I've attached my sheet and the positive time values return the accurate time difference. However, when a negative value is added there's no output.
I've also noticed that if I add the positive values together individually I don't get any issues with a total, whereas if I use Autosum for the same section then I get nothing returned (shown in the nov calcs tab).
appreciate any advice on making this work.
thanks
Nick
Bookmarks