View Single Post
 
Old 09-05-2011, 05:30 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
In that case you need to format your start and finish collumns as follows:
dd/mm/yyyy hh:mm
The enter your start and end times in that format.
Then in your result column format your cells as:
hh:mm
You can then subtract the Start column from the Finish column in your results column and you will get the number of hours and minutes your staff worked.
Hope this helps.
Good luck.
Tony(OTPM)
Reply With Quote