On Tue, 18 Oct 2005 18:07:37 -0500, Ltat42a
<
[email protected]> wrote:
>
>The form I'm using does have a cell for the date that the overtime is
>worked. The formula I'm using does not reference that cell.
>
>If the date cell was included in the formula, is there a way the time
>calculation can be changed to reflect 24 hours instead of 0?
>
>Thanx
>
>JF
I'm not sure I understand the form.
But if you are entering a start time and a stop time, and the difference could
be more than 24 hours, you need to somehow also reference a start date and stop
date. If this could be obtained from some other cells, then the formula you
would use would be:
=24 * ((StopDate+StopTime) - (StartDate+StartTime))
Format the result as number with an appropriate number of decimal places.
The logic:
Excel stores dates as serial numbers (starting with 1/1/1900 or 1/1/1904) and
times as fractions of a day. So the above formulas merely combine to produce
what you would obtain if you entered the date and time in the same cell.
Multiplying by 24 transforms the result into decimal hours, which can then be
multiplied by an hourly rate.
--ron
Bookmarks