By way IT WORKED big tnx there to Ed... I had to make sure that the proper time was selected, I thought I had selected HH:MM but I had hh:mm:ss which is 12 hr time.
On Sat, Nov 8, 2014 at 11:41 AM, Chuck Hast <[email protected]> wrote: > All I needed was Time worked rate and amount billed. > That worked, since timeclock already does all of the > other calculations all I do is move the duration from > TimeClock to the invoice, now I will modify my invoice > to where it can handle the time rather than my having > to convert it to decimal > > > > On Sat, Nov 8, 2014 at 10:58 AM, King Beowulf <[email protected]> > wrote: > >> 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 >> > > > > -- > > Chuck Hast -- KP4DJT -- > Glass, five thousand years of history and getting better. > The only container material that the USDA gives blanket approval on. > > > -- 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 [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
