I am going out of my mind. I really don't want to enter "10:00" or "09:45" everytime - I use a numpad and I don't wanna keep "Shift+;"ing.
I have three columns: Shift start / Time started / Lateness
I want to enter "0930"[b1] / "1030"[b2] / and [=b1-b2] outputs "45"
e.g. "0930"/"1100"/"90" or "0930"/"1100"/"1:30"
- Or at least something like this that would be simple to use. This seems like such a straight forward function but I can't figure out how to make it work!
- see attachment for example
Excel Type (Windows)
Excel Version (2002 at home Office 365 at work)
Excel Environment (desktop)
Knowledge Level (Intermediate I guess)
Bookmarks