Converting minutes

[mkb-bf]

I have time sheets from the past I need to enter but have found that some years the time punch minutes are given as if an hour equals 100 minutes not 60. Other years the minutes are given correctly. How do I format this field so that if I type 3.75 it will convert to 3.45 hours? Will I have to add another field to enter this and then convert to my field where hours and minutes are correctly entered?

 

[Pat Hartman]

You will need a separate field for data entry and you will need to convert the data. Time in a date/time field is entered as hh:mm:ss.

 

[mkb-bf]

Thanks.....I was afraid it was going to have to be that way.