Joined: 02 Aug 2011
Location: United States
Online Status: Offline
Posts: 2
Topic: How to convert a time field in seconds Posted: 02 Aug 2011 at 8:11am
I need to be able to convert a summary field to hours and minutes as follows:
Field in database: seconds
I'm running a rolling time sheet for a generic time and attendance application we have installed.
I need to summarize the seconds from each day in the group footer as a SUM and then convert the SUM to hours and minutes. I have the individual days being converted to hours and minutes displayed using totext functions, but I can't figure out how to do the same thing to the summary field.
Hopefully I'm just missing something simple... Please help!!
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 02 Aug 2011 at 11:54am
Instead of just clicking on the Summary button to create your summary, create a formula that does the same thing. You'll need to have a group on the Date and the formula will look something like this:
sum({table.seconds}, {table.date})
You can then convert this formula the same way that you're converting your other fields.
Joined: 02 Aug 2011
Location: United States
Online Status: Offline
Posts: 2
Posted: 03 Aug 2011 at 2:45am
Thanks - problem solved. I knew it would be something easy. I've used Crystal on and off for about 10 years, but never got too in depth. Thanks for the response so quickly.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
