Hi all
I am currently temping for a agency and the time logging system they use is a bit dodjy to say the least.
I log in using a e-trac asp system (their clock is fast by 5.43 mins ) and the logging is to the minute but the agency round the time to the closest 15mins!
Can I get my exel spreadsheet to round time to the closest 15 mins
e.g. 09:00 - 09:07 = 09:00 & 09:08 - 09:15 = 09:15
Help please
as i lost half an hour of pay last week to this dodgy system
Thanks
Bookmarks