Hello -
I feel like I should know how to do this but can't seem to figure it out. :banghead:
I have two fields in a query "Goal Time" and "Actual Time". They are imported from an Excel spreadsheet and the imported data type is short text.
The data in these fields is equal to the amount of time it should have taken them to complete an assignment versus the actual time it took them. The format is hh:nn:ss so a goal time of 00:17:55 means they should have completed the assignment in 17 minutes 55 seconds.
I am trying to do a simple calculated field that shows the difference between the actual time and the goal time. I have tried converting to different formats but it returns either #Error or #Func!.When I do Time Value it actually converts it to an AM/PM format.
What I want to see is a goal time of 00:17:55, an actual time of 00:17:00, a difference of 00:00:55.
How can I get it to return the difference between the two fields?
Thank you in advance!
I feel like I should know how to do this but can't seem to figure it out. :banghead:
I have two fields in a query "Goal Time" and "Actual Time". They are imported from an Excel spreadsheet and the imported data type is short text.
The data in these fields is equal to the amount of time it should have taken them to complete an assignment versus the actual time it took them. The format is hh:nn:ss so a goal time of 00:17:55 means they should have completed the assignment in 17 minutes 55 seconds.
I am trying to do a simple calculated field that shows the difference between the actual time and the goal time. I have tried converting to different formats but it returns either #Error or #Func!.When I do Time Value it actually converts it to an AM/PM format.
What I want to see is a goal time of 00:17:55, an actual time of 00:17:00, a difference of 00:00:55.
How can I get it to return the difference between the two fields?
Thank you in advance!