Time Calculation - Total Min to Hrs and Min?

[theyetti]

Hi All, hopefully this one isn't going to be as hard as I think it is.

I want to record my working time for the day, I start at 8:00am and finish at 4:30pm with 30mins for lunch. I've worked out daily total in minutes (480 usually) but I would like to display this as hour and minutes. For instance if I start at 8:10am my total for the day would be 470 minute and I would like to display as 7:50. This last part I can't work out - Is it possible?

Thanks Pedro -)

[LaRetta]

Calculation = 470 * 60 and make result a time field (use your minutes field in place of the 470). Then manipulate the display: right-click field, select Time Format.

However, I would bet it can be simplified if I knew the fields in question. Can you post your test file?

Edited August 12, 2006 by Guest

[theyetti]

Hi LaRetta, thanks, it works prefectly -)

I've already reduced the fields and calculations to the minimum needed but had trouble with displaying the data as I wanted it.

I kept on thinking I had to divide to get the correct result.

Kind Regards,

Pedro :-)

Edited August 12, 2006 by Guest