Hey guys. Hopefully you guys can understand what I mean and can help me out!
A1 = time start using (cntrl+shift+ which shows 4:00 AM
B1 = time end using (cntrl+shift+ which shows 8:00 AM
C1 = time between using =MOD(B1-A1,1) which shows 4:00:00
D1 = time from C3 converted into minutes using =C1*1440 which shows 240 minutes
E1 = D1 new value - D1 old value (Example: if old value was 240, and new is 360, then 360-240 = 120.)
I have A1, B1, C1, and D1, and not sure how to formulate E1. I came across a few results on google about returning old value, and I got results that had to do with VBA, which didn't go step by step how to set it up, just provide the code. If my problem does require a VBA code, I'd appreciate if you could also include step by step on how to set it up and run it! I would greatly appreciate it! Thanks in advance, and to those who have no idea what I am trying to accomplish, I am sorry, and I will do my best to explain it more in detail as you wish.
A1 = time start using (cntrl+shift+ which shows 4:00 AM
B1 = time end using (cntrl+shift+ which shows 8:00 AM
C1 = time between using =MOD(B1-A1,1) which shows 4:00:00
D1 = time from C3 converted into minutes using =C1*1440 which shows 240 minutes
E1 = D1 new value - D1 old value (Example: if old value was 240, and new is 360, then 360-240 = 120.)
I have A1, B1, C1, and D1, and not sure how to formulate E1. I came across a few results on google about returning old value, and I got results that had to do with VBA, which didn't go step by step how to set it up, just provide the code. If my problem does require a VBA code, I'd appreciate if you could also include step by step on how to set it up and run it! I would greatly appreciate it! Thanks in advance, and to those who have no idea what I am trying to accomplish, I am sorry, and I will do my best to explain it more in detail as you wish.