Feb 23, 2010 #1 willpp MIS Joined Feb 12, 2010 Messages 7 Location GB at present it shows as 65 minutes duration but i would like it to show as 1 hour 5 minutes then add a grand total in hour and minutes I would be grateful for any help
at present it shows as 65 minutes duration but i would like it to show as 1 hour 5 minutes then add a grand total in hour and minutes I would be grateful for any help
Feb 23, 2010 1 #2 Madawc Programmer Joined Sep 5, 2002 Messages 7,628 Location GB Divide by 60. Then do the same again using REMAINDER. String the two together as text items in a formula field. Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP Upvote 0 Downvote
Divide by 60. Then do the same again using REMAINDER. String the two together as text items in a formula field. Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP
Feb 23, 2010 1 #3 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US I'd convert hours to DAYS and then use standard TIME formatting to display hh:mm. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
I'd convert hours to DAYS and then use standard TIME formatting to display hh:mm. Skip, Just traded in my old subtlety... for a NUANCE!