Calculate Start/End TimesDec 20, 2006
Trying to get times worked in hours and mins, from a given start time to a given finished time.
I would like H18 to read 14
and H19 to read 13.5 and so on,
H23 and H24 are full 24 hour coverage,
but i get a 0, when using 08:00 - 08:00
as we only deal with a full or half hours, the figures should read whole numbers or half number as in th example above.
Also would like to total all hours worked in H28 to 117 as opposed to the figure given in the attached file.
DAY / DATESTARTENDHOURS
Couldnt upload the file as it was 75kbs, a