What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

    
  1. Re: [WebDNA] Converting minutes to hours (Brian Fries 2008)
  2. Re: [WebDNA] Converting minutes to hours (Jeffrey Jones 2008)
  3. Re: [WebDNA] Converting minutes to hours (Terry Wilson 2008)
  4. Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
  5. Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
  6. Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
  7. Re: [WebDNA] Converting minutes to hours (Terry Wilson 2008)
  8. Re: [WebDNA] Converting minutes to hours (Matthew Bohne 2008)
  9. Re: [WebDNA] Converting minutes to hours (Gary Krockover 2008)
  10. Re: [WebDNA] Converting minutes to hours (Matthew Bohne 2008)
  11. [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
[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:

date tag not interpreted (2000) switching users (1998) GuestBook example (1997) Re:Saving/Looking Up customer numbers (1998) WC2.0 Memory Requirements (1997) LetterRip and WebCat (1998) Hairy Shipping Monster (2006) Webdna 5.0 reference documentation (2003) What is WebDNA (1997) Append command(2) (2000) [Sum] function? (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997) multiple prices (1998) presetting a [math] var not working (2000) (1997) suggestions for a good text editor on windows? (2005) Frames (1997) webcat NT (1998) inetinfo.exe (1999) [WebDNA] Need to convert unix date? (2009)