Jump to content

Time Calculation - Total Min to Hrs and Min?


This topic is 5590 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 :(-)

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5590 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.