Calculate time

[Guest]

I have a form to enter how much time is spent doing specific functions.
There are two fields for the amount of "hours" and "Minutes" spent. How can
I get the time to wrap minutes in to hours to have a total amount of time
spent for the day in a report? or subsequently in to a report/query for a
longer timeframe, like a whole week?

 

[Guest]

To change the field type from number to text, open the table in design view,
locate the cursor in the desired field, and change the field type.

A reason for the number to round is if the field type is long or integer, if
you don't want the number to round then change it to Double or single