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.
A further observation. The 0.2 (strictly speaking 0.020833) was perfectly correct as a proportion of the day. The formatting could be more helpful though. A custom number format [h]:mm will provide a meaningful display of 0:30.
- Yes, and I did have that as a back up option, but the decimal solution was what I was hoping to achieve. I appreciate the feedback though, thank you!
