I'd like to hopefully find a way of capturing then reporting on the time a task was completed. I currently have a workflow that updates a Date/Time field with NOW() when it is marked as compete however, this field is difficult to report on as you cant summarise reports by time, juts the date element of that field.
Has anyone got a solution for this? Would be great to be able to report on time!
Thanks,
Alastair
11 answers
You could add a formula field and use the formula MID(TEXT(Completed_Date__c), 12, 5)
to extract the time value from your DateTime field. You may just need to offset the Completed Date of that field to suit your timezone, so for me the formula I needed was
MID(TEXT(Completed_Date__c + 0.04167), 12, 5)
The significance of 0.04167 by the way is that it represents one hour difference from GMT, so I'm adding one hour to reflect my timezone.
Let us know how you get on!
