Hello all!
I am making a time sheet which is sometimes dealing with timezone differences.
Because of timezone differences, I need to be able to subtract for example 4 hours from the time 01:00.
This should then give med the time 21:00.
The Excel sheet (should) look like this:
Date |
From Time |
To Time |
Hours |
Comment |
26/1 |
01:00 |
21:00 |
4,0 |
-4 hours Zone difference |
This piece of code will first detect if the deviation is a negative number, and then re-calculate the "ToTime".
This do work as long as it don't crash with midnight.
The code is made like this due to some hints I have found on the web earlier on, but I just don't understand
what happens within it
Any help on how to solve this line of code is greatly appreciated!
Bookmarks