Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101183
interpreted = N
texte = We actually don't round time off...all time is entered in 15 minute increments. On Oct 15, 2008, at 3:48 PM, Matthew Bohne wrote: > How do the minutes round? For instance, is 4:07 rounded to 4:00 or > 4:15? What about 4:58? > > Suzanne Swift wrote: >> I'm trying to convert minutes to hours to simplify a payroll >> process. My minutes are tallied in either 15, 30 or 45 minute >> increments. In order to add the hours and minutes together >> properly, I need to figure out a way to convert the minutes to part >> of an hour and then multiple by the pay rate. Does anyone know how >> to do this using WebDNA version 3.0? >> >> Here's a code snippet... >> >> Total Time worked: [HoursTotal] hrs and [MinutesTotal] minutes >>
>> Total Cost: $[math][HoursTotal]*[lookup >> db=my.db&value=[Employee]&lookInField= Employee&returnField= >> Employee_Rate¬Found=][/math]
>> >> Thanks! >> Suzanne >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list
. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> >> > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
We actually don't round time off...all time is entered in 15 minute increments. On Oct 15, 2008, at 3:48 PM, Matthew Bohne wrote: > How do the minutes round? For instance, is 4:07 rounded to 4:00 or > 4:15? What about 4:58? > > Suzanne Swift wrote: >> I'm trying to convert minutes to hours to simplify a payroll >> process. My minutes are tallied in either 15, 30 or 45 minute >> increments. In order to add the hours and minutes together >> properly, I need to figure out a way to convert the minutes to part >> of an hour and then multiple by the pay rate. Does anyone know how >> to do this using WebDNA version 3.0? >> >> Here's a code snippet... >> >> Total Time worked: [HoursTotal] hrs and [MinutesTotal] minutes >>
>> Total Cost: $[math][HoursTotal]*[lookup >> db=my.db&value=[Employee]&lookInField= Employee&returnField= >> Employee_Rate¬Found=][/math]
>> >> Thanks! >> Suzanne >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> >> > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Suzanne Swift
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
multi-paragraph fields (1997)
how to construct a search for not this entire string? (2000)
WebCommerce: Folder organization ? (1997)
unitShipCost - setlineitem (2002)
Pithy questions on webcommerce & siteedit (1997)
[Sum] function? (1997)
Date search bug (1998)
A sendmail warning (2005)
Running _every_ page through WebCat ? (1997)
PARAMETER vs. OPERATOR (was The BUG is BACK ...) (1998)
Https not showing products (2004)
changing creator codes (2000)
Weeks starting on Mondays (1998)
setheader and retrieve it immediatly (2001)
[WebDNA] timestamp conversion (2011)
Can [writefile] files be served thru webcat? (2000)
Making a page expire with web catalog? (1999)
Help name our technology! (1997)
SUMM=T does not summarize by the sort parameters ... (2003)
suffix mapping for NT? (1997)