Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Time calculation


TanyaI
 Share

Recommended Posts

Hi probably a simple one for you guys. I have a date and time of sample collection, 2 fields one is a date field the other a number field. (Thinking about it it maybe should be a time field.) Then I have a date field and number field for time processed. I want a calculation that will tell me the number of hours between these two points in time. Thanks Tanya

Link to comment
Share on other sites

Why not switch them to one timestamp field?  One for timestamp of collection and one for timestamp of processed.  You can format them to only show hours.

Then the calc is simply one minus the other.

Here's a post on this forum about time and timestamps:

 

Link to comment
Share on other sites

Thanks Steve. We already have thousands of records in this format. Is there an easy way to convert these as this does seem like a great plan

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use