Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you change minutes into Hours 2

Status
Not open for further replies.

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


 
Divide by 60. Then do the same again using REMAINDER. String the two together as text items in a formula field.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP [yinyang]
 



I'd convert hours to DAYS and then use standard TIME formatting to display hh:mm.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top