Forum Discussion
Solved
Help, Excel Noob, Shift Time Conversion to Negative???
Hello, I'm sorry to both you all, but I'm a novice when it comes to working with Excel. I'm trying to merge some excel sheets and have decided to do so from scratch to get a feel and understanding ...
SWebster95 Try it like this:
=([@[Shift End]]-[@[Shift Start]])*24I.e. put round brackets around the subtraction. Otherwise, you deduct the End time multiplied by 24 from the Start time.
SWebster95 Try it like this:
=([@[Shift End]]-[@[Shift Start]])*24I.e. put round brackets around the subtraction. Otherwise, you deduct the End time multiplied by 24 from the Start time.
This was exactly it. Thank you! I knew it was something simple too, haha. Just staring at it for too long I guess, didn't see it.