[PLUG] Of time and spreadsheets

[Tyrell Jentink]

You have to have a "duration" field. I end up having a Time In and a Time
Out, which are of the type Time. I then take the difference, and set that
field to Duration. Then I can multiply that duration by the rate (I THINK
duration is in seconds, so I ended up having to divide it by 3600? You will
want to verify that).

I'm on my phone... So excuse the brevity. If you need more
details/examples, I can provide them later today.
On Nov 8, 2014 9:56 AM, "Chuck Hast" <wchast at gmail.com> 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.
> --
>
> Chuck Hast  -- KP4DJT --
> Glass, five thousand years of history and getting better.
> The only container material that the USDA gives blanket approval on.
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>