I am trying to calculate totals hours worked in my report. The fields that I am originally using are a string and I converted to time field by using the ctime formula. So for my formula I was trying to use the datediff function and when I do an error checking it errors out and says I need the field to be a datetime or time field. I also a changed the field format to a 24 hour clock.
This is what I want to accomplish EndTime (ex.16:00) - StartTime (ex 08:00) = total hours worked (ex 8:00)
This is driving me crazy for something simple in theory has to be so frustrating implementing it.
Any help is appreciated