Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101180
interpreted = N
texte = Here is a simple version. I have a function somewhere that will let you specify decimal places, rounding, etc. But this should be what you are looking for: [math][HoursTotal]+(((floor((([MinutesTotal]+7)/60)*4))*15)/60)[/math] Depending on how you round, change the number '7' in the above formula. If you always round down, just change it to zero. If you always round up, change it to 14. 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:
Here is a simple version. I have a function somewhere that will let you specify decimal places, rounding, etc. But this should be what you are looking for: [math][HoursTotal]+(((floor((([MinutesTotal]+7)/60)*4))*15)/60)[/math] Depending on how you round, change the number '7' in the above formula. If you always round down, just change it to zero. If you always round up, change it to 14. 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/ > >
Matthew Bohne
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:
WebCatalog not running after upgrade (2000)
[WebDNA] Ubuntu 18.04 & Apache2 & WebDNA fcgi - File upload error (2019)
wrong input values? (1997)
Date Time Oddness (1999)
Limit on nested [ShowIf]'s? (1997)
SSL and reg web* (1997)
searching multiple databases in single search (1997)
WebCatalog for Postcards ? (1997)
shipcost (1997)
Range Comparisons (2000)
'does not contain' operator needed ... (1997)
I'm new be kind (1997)
FORMS: Returning a specific page (1997)
Forms IMG tag[OT] (2001)
How to remove comments with grep? (2003)
SiteGuard Admin Feature ? (1997)
Frames and WebCat (1997)
need help with [sendmail] and [showif]s (1998)
[WebDNA] Passing a text variable via copyfile (2019)
email [title] (1997)