Feb 23, 2010 #1 willpp MIS Feb 12, 2010 7 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 Sep 5, 2002 7,628 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 Dec 4, 2001 47,492 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!