Hello I have a spreadsheet formatted to time format. With over 1000 times.
Im trying to calculate the times between 2 cells, whether its a plus or minus. So for example if cell a2 is 19:00 and cell b2 is 19:30 there is difference of -30 minutes as its late.
However if cell b2 is 16:30 then its a plus 02:30 hours as its early..
Any ideas how i can work this out?
Thanks in advance for any help anyone can give me
Im trying to calculate the times between 2 cells, whether its a plus or minus. So for example if cell a2 is 19:00 and cell b2 is 19:30 there is difference of -30 minutes as its late.
However if cell b2 is 16:30 then its a plus 02:30 hours as its early..
Any ideas how i can work this out?
Thanks in advance for any help anyone can give me