Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101187
interpreted = N
texte = [math]([HoursTotal]+[MinutesTotal]/60)*[lookup ...][/math] Brian Fries BrainScan Software On Oct 16, 2008, at 5:49 PM, Jeffrey Jones wrote: > Wouldn't it be easier to convert the hours to minutes, add the extra > minutes, then multiply by the hourly rate/60? > > -Jeff > > On Oct 15, 2008, at 7:57 PM, Terry Wilson wrote: > >> Glad to help! Please fix the accidental space that crept in there >> before the 1st showif though. >> >> Terry >> >>> Thank you! I figured I might have to go this route...just thought >>> WebDNA might have a tag that did it for me. Thank you (and >>> everyone else who responded). As a newbie programmer working on >>> "old" code, I appreciate the help! >>> >>> On Oct 15, 2008, at 4:16 PM, Terry Wilson wrote: >>> >>>> Since you are entering either 15, 30, or 45 for the minute >>>> portion, do it like so: >>>> >>>> Total Cost: $[math][HoursTotal] [showif [MinutesTotal]=15].25[/ >>>> showif][showif [MinutesTotal]=30].5[/showif][showif >>>> [MinutesTotal]=45].75[/showif]*[lookup >>>> db=my.db&value=[Employee]&lookInField= Employee&returnField= >>>> Employee_Rate¬Found=][/math] >>>> >>>> Terry >>>> >>>>> 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/ >>>> >>>> --Terry Wilson | terry@terryfic.com | http://terryfic.com >>>> http://WhosComing.com - a simplified, affordable online >>>> reservation system >>>> http://TightJacket.com -- stylish protection for your laptop >>>> -------------------------------------------------------------------------- >>>> Attitude is the only difference between ordeal and adventure. >>>> --------------------------------------------------------- >>>> 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/ >> >> -- >> Terry Wilson | terry@terryfic.com | http://terryfic.com >> http://WhosComing.com - a simplified, affordable online reservation >> system >> http://TightJacket.com -- stylish protection for your laptop >> -------------------------------------------------------------------------- >> Attitude is the only difference between ordeal and adventure. >> --------------------------------------------------------- >> 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:
[math]([HoursTotal]+[MinutesTotal]/60)*[lookup ...][/math] Brian Fries BrainScan Software On Oct 16, 2008, at 5:49 PM, Jeffrey Jones wrote: > Wouldn't it be easier to convert the hours to minutes, add the extra > minutes, then multiply by the hourly rate/60? > > -Jeff > > On Oct 15, 2008, at 7:57 PM, Terry Wilson wrote: > >> Glad to help! Please fix the accidental space that crept in there >> before the 1st showif though. >> >> Terry >> >>> Thank you! I figured I might have to go this route...just thought >>> WebDNA might have a tag that did it for me. Thank you (and >>> everyone else who responded). As a newbie programmer working on >>> "old" code, I appreciate the help! >>> >>> On Oct 15, 2008, at 4:16 PM, Terry Wilson wrote: >>> >>>> Since you are entering either 15, 30, or 45 for the minute >>>> portion, do it like so: >>>> >>>> Total Cost: $[math][HoursTotal] [showif [MinutesTotal]=15].25[/ >>>> showif][showif [MinutesTotal]=30].5[/showif][showif >>>> [MinutesTotal]=45].75[/showif]*[lookup >>>> db=my.db&value=[Employee]&lookInField= Employee&returnField= >>>> Employee_Rate¬Found=][/math] >>>> >>>> Terry >>>> >>>>> 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/ >>>> >>>> --Terry Wilson | terry@terryfic.com | http://terryfic.com >>>> http://WhosComing.com - a simplified, affordable online >>>> reservation system >>>> http://TightJacket.com -- stylish protection for your laptop >>>> -------------------------------------------------------------------------- >>>> Attitude is the only difference between ordeal and adventure. >>>> --------------------------------------------------------- >>>> 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/ >> >> -- >> Terry Wilson | terry@terryfic.com | http://terryfic.com >> http://WhosComing.com - a simplified, affordable online reservation >> system >> http://TightJacket.com -- stylish protection for your laptop >> -------------------------------------------------------------------------- >> Attitude is the only difference between ordeal and adventure. >> --------------------------------------------------------- >> 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/
Brian Fries
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 for guestbook ? (1997)
Setting up shop (1997)
[WebDNA] hide [DOS] command strings on resulting page (2016)
[format 40s]text[/format] doesn't work (1997)
shipcost (1997)
Size of a folder? (2003)
WCS Newbie question (1997)
default image if image in code not available (2003)
WebCat2b13 Command Reference Doc error (1997)
RE: type 2 errors with ssl server (1997)
Web Developer Product Awards (1997)
NetSplat and WebCat2 (1997)
Template not found error messages (1997)
2.0 Info (1997)
Just Testing (1997)
can WC render sites out? (1997)
test (2000)
WebCatalog vs. Cold Fusion (1998)
PCS Emailer's role ? (1997)
what's wrong with this picture (2006)