|
-
Jul 25th, 2008, 05:16 PM
#13
Thread Starter
Fanatic Member
Re: [02/03] Select statement help required please
No problem, you can see an example in post number my earlier post where I have posted a url.
I think I understand where the problem is coming from.
If we take the following data as an example:
names timespent
bob 0:30
dave 1:00
fred 1:45
george 2:15
albert 0:15
If I sum these up I get .29 of a day or 5 3/4 hours which is right. My Sum is currently in terms of days or a fraction of a day but would it be possible to show my data in the hourly format?
Rather than showing it in a day format, I want to show it in the hourly format.
THanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|