Forum Discussion
Eric_J_Hansen
9 years agoQrew Cadet
Oh, I think I understand what you are trying to do...
If you want to know the difference in hours and minutes between 2 separate fields, a date/time and just a time (time of day) field, you might do something like this:
Create a formula duration field and make this the formula (you can reverse the order):
Then, set your duration field properties to HH:MM.
That should do it my friend!
If you want to know the difference in hours and minutes between 2 separate fields, a date/time and just a time (time of day) field, you might do something like this:
Create a formula duration field and make this the formula (you can reverse the order):
ToTimeOfDay([Date/Time Field])-[Time of Day Field]
Then, set your duration field properties to HH:MM.
That should do it my friend!
CasameiraReyes
9 years agoQrew Cadet
It is not giving me the correct time. Something which should be 00:07 ends up being 12:07