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)
|