VB Crystal Report, still working on the @#$!-ing timesheet report

still working on the @#$!-ing timesheet report - need help with TLs

Author	Message
andrea.domingue #1 / 3	still working on the @#$!-ing timesheet report - need help with TLs Hello, This is the formula I have so far If trim({cal.ref})="Sign Out" then TimeValue ({cal.Createat}) - TimeValue (Previous({cal.Createat} )) So if the user does a "Sign In" at 5:05 p.m. and a "Sign Out" at 6:51 it returns a value of 6360. The value is correct in seconds. I need to make it 12 hour format. So instead of 6360 I need it to be 1:46. How the heck do I do that? and {cal.createat} is in military time and a character field TIA for the help
Tue, 06 Dec 2005 11:53:08 GMT

Charl #2 / 3	still working on the @#$!-ing timesheet report - need help with TLs Divide it by 60 and you've got minutes, divide that by 60 and the result is hours and the remainder is the mnutes. Date: Thu, Jun 19, 2003 10:53 PM Hello, This is the formula I have so far If trim({cal.ref})="Sign Out" then TimeValue ({cal.Createat}) - TimeValue (Previous({cal.Createat} )) So if the user does a "Sign In" at 5:05 p.m. and a "Sign Out" at 6:51 it returns a value of 6360. The value is correct in seconds. I need to make it 12 hour format. So instead of 6360 I need it to be 1:46. How the heck do I do that? and {cal.createat} is in military time and a character field TIA for the help >>
Wed, 07 Dec 2005 09:16:02 GMT

andrea.domingue #3 / 3	still working on the @#$!-ing timesheet report - need help with TLs I feel like such a dweeb for asking but what would the formula look like? Quote: > Divide it by 60 and you've got minutes, divide that by 60 and the result is > hours and the remainder is the mnutes. with TLs > Date: Thu, Jun 19, 2003 10:53 PM > Hello, > This is the formula I have so far > If trim({cal.ref})="Sign Out" then > TimeValue ({cal.Createat}) - > TimeValue (Previous({cal.Createat} )) > So if the user does a "Sign In" at 5:05 p.m. and a "Sign Out" at 6:51 it > returns a value of 6360. The value is correct in seconds. I need to make it > 12 hour format. So instead of 6360 I need it to be 1:46. > How the heck do I do that? > and {cal.createat} is in military time and a character field > TIA for the help
Wed, 07 Dec 2005 10:16:43 GMT

Page 1 of 1

[ 3 post ]