Re: 09:45:00 -> 9.75
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38721
interpreted = N
texte = I hope this helps, but in excel if you have time and divide it by 0.04166667 it will give you the amount in a number format that you want.8:30/0.04166667=8.5Now how you can apply this to WebCatalog I am not sure. all I know is that 0.04166667 is the magical number----- Original Message ----- From: Will Starck
To: WebCatalog Talk Sent: Tuesday, September 18, 2001 7:17 PM Subject: Re: 09:45:00 -> 9.75 Clip off the minutes and divide by 60?This works:[text]hours=09:45[/text] Hours and minutes worked=[hours]
[math show=f]hoursworked=[math]([listwords words=[hours]&delimiters=:][showif [index]=1][word][/showif][/listwords])+([listwords words=[hours]&delimiters=:][showif [index]=2][word][/showif][/listwords]/60)[/math])[/math]Fractional hours worked=[hoursworked]See this in action here http://www.novaderm.com/test/testthis.tplThere might be a spiffier way to do it - I tried to make it cleaner by placing the [math]s inside of a single [listwords] but couldn't get that to workGood luck,Will Starck NovaDerm skin care science http://www.novaderm.com techs@novaderm.com 800-378-1740----- Original Message ----- From: Aaron Lynch To: WebCatalog Talk Sent: Tuesday, September 18, 2001 7:58 PM Subject: 09:45:00 -> 9.75 > I have a bunch of times in a database, in 24hr form. > > I need to be able to figure out the hours between em. > > This code: [math time]({[out]}-{[in]})-({[in.lunch]}-{[out.lunch]})[/math] > > Gets me 09:45:00 which is the right amount of time. > > But I'd like to display that as 9.75 and I can't seem to figure out how. > > > > -- Aaron Lynch > System Administrator > NineWire Digital Solutions || http://ninewire.com > > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I hope this helps, but in excel if you have time and divide it by 0.04166667 it will give you the amount in a number format that you want.8:30/0.04166667=8.5Now how you can apply this to WebCatalog I am not sure. all I know is that 0.04166667 is the magical number----- Original Message ----- From: Will Starck To: WebCatalog Talk Sent: Tuesday, September 18, 2001 7:17 PM Subject: Re: 09:45:00 -> 9.75 Clip off the minutes and divide by 60?This works:[text]hours=09:45[/text] Hours and minutes worked=[hours]
[math show=f]hoursworked=[math]([listwords words=[hours]&delimiters=:][showif [index]=1][word][/showif][/listwords])+([listwords words=[hours]&delimiters=:][showif [index]=2][word][/showif][/listwords]/60)[/math])[/math]Fractional hours worked=[hoursworked]See this in action here http://www.novaderm.com/test/testthis.tplThere might be a spiffier way to do it - I tried to make it cleaner by placing the [math]s inside of a single [listwords] but couldn't get that to workGood luck,Will Starck NovaDerm skin care science http://www.novaderm.com techs@novaderm.com 800-378-1740----- Original Message ----- From: Aaron Lynch To: WebCatalog Talk Sent: Tuesday, September 18, 2001 7:58 PM Subject: 09:45:00 -> 9.75 > I have a bunch of times in a database, in 24hr form. > > I need to be able to figure out the hours between em. > > This code: [math time]({[out]}-{[in]})-({[in.lunch]}-{[out.lunch]})[/math] > > Gets me 09:45:00 which is the right amount of time. > > But I'd like to display that as 9.75 and I can't seem to figure out how. > > > > -- Aaron Lynch > System Administrator > NineWire Digital Solutions || http://ninewire.com > > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Arturo Vargas
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:
Sorting a Search... (1998)
Or Operator (2005)
Separate SSL Server (1997)
Sorting Results (1999)
2.0 Info (1997)
Rendering out a page (1997)
Huge Problem installing Secure Certs (2006)
Extended [ConvertChars] (1997)
Adding Message to Order (1997)
[searchString] (1997)
WebCat2b15MacPlugin - [protect] (1997)
Mac v. NT (1998)
Comments in db? (1997)
WC TableGrinder (1997)
Moving a record from one dataabse to another. (2000)
PSC recommends what date format yr 2000??? (1997)
[WebDNA] WebDNA installers (2015)
Mac v. NT (1998)
More on the email templates (1997)
Cobalt RaQ (2000)