Hi,
I am working on a timesheet (attached) that i hope will allow me to calculate the number of hours that are worked between 2200 and 0600, i have used the formula below
=(G4-F4)*24-MEDIAN(22,6,MOD(G4,1)*24)+MEDIAN(22,6,MOD(F4,1)*24)-(INT(G4)-INT(F4))*(22-6)
The number should be given in column K, however i am getting back 0 when the number should be 8 (with regards to the information that i have inputted to attempt the equation). column K is also formatted as number...
If anyone is able to assist me with where i am missing something that would be most appreciated
Many Thanks
Bookmarks