Search results

This code worked fine in Access 2003 to convert time into the format 00:00:00, but it is not working in Access 2007. I need help with how to modify this code. Function ConvertMinutes(minutes As Variant) As String If IsNull(minutes) Then ConvertMinutes = "N/A" Else Dim...

This is for a report. I have a module that converts 1h 2m into 1:02:00. I'm trying to sum the time for a group, Production. =ConvertMinutes(Sum([sys_eusername]='Production')) However, it is giving me a negative time return. And Access does not seem to like if I try...

This is for a report. I'd like to convert minutes to time in the format: hh:mm:ss Example: 4762 minues is 79:22:00 The field is: sys_request_hdmins This is figured for an 8 hr. work day.

Hello, The table I work with is my employment's help desk database. I need to add up each of the values of the usr_origin field and the total of the usr_elaspedtime field that corralates with each value of the usr_origin field. There are 16 different values for the usr_origin. As an...