On 11/08/2014 09:54 AM, Chuck Hast wrote:
> Folks,
> I am trying to figure out how to handle time in a spreadsheet. I need
> to enter the time hh:mm and then the hourly billing and obtain a billing
> value for that time entered. Presently I just round the minutes to the
> nearest 15 minute value, i.e. .25, .5, .75 or 1. But I would actually like
> to have the spread sheet take the actual worked time from my time
> clock app and not have the manipulate it so that it turns out correct.
>
> I have looked but so far what I find is not exactly what I need.
>
> In summary, I have three columns
> time hh:mm | rate | amount billed
>
> The time is in 24hr format I do not have time to piss around with a.m.
> p.m. so it will be 0-23 hrs, and minutes 0-59. I am trying to figure out
> how to do the math so that the hours and minutes x rate will give me
> the correct numbers in the amount billed column.
>
Make sure you format the spreadsheet cells as TIME format, e.g.,
HH:MM:SS (24 hr without AM/PM). Then
Time in | Time out | Time worked | Rate | Amt Billed
10:20 | 13:50 | =A2-B2 | $10.00 | C2*24*D2
(03:30:00) ($35.00)
You'll have to but some logic in if your time crosses Midnight. If your
time clock already spits out "time worked" this will still work as long
as the "time Worked" cell is formatted as 24hr TIME (HH:MM) and not TEXT
or NUMBER - which may be the default setting.
(Tested with Libreoffice/OpenOffice Calc)
-Ed
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
