Hi Dave
With start time in A1 and finish time in B1
=MOD(B1-A1,1)
will calculate the interval, even allowing for times that cross the
divide between one day and the next.
Excel store its times as fractions of a day, so if you need to multiply
hours by rate per hour, you first need to multiply the hours calculated
by the above formula by 24, to bring them to a decimal value.
--
Regards
Roger Govier
"Dave Davis" <Dave
wrote in message
...
Is there a template out there that calculates time for hours worked.