Date/Time calculated field to the hour
I'm trying to create exception reports for tracking records going through a workflow process using calculations and DDEs, not advanced workflow.
Essentially, members of 6 different groups touch each record for various reviews and approvals. I'd like to have a Date/Time field off layout for measuring the amount of time between signoffs. I believe there is already a Date/Time field capturing the Date/Time of each level of signoff. What I want to do is capture the difference between signoffs using hours rather than days, for example 3 days would display as 72 hours. What is the best way to do this?
I know I can create calculated fields to measure the difference between two fields, but have never a need to measure to the hour like this before. Once I am able to capture the amount of time in hours between signoffs, I will be creating exception reports for each stage in the process.
Thanks for your help!
Dennis you can use the DATEDIF function; it has a parameter for HOUR along with start and end date. Just be aware if the date field doesn't have time option configured it will be stored in the database as GMT 12:00 so your hours could be a little off based on the users time zone.