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 [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
