Jump to content
TanyaI

Time calculation

Recommended Posts

TanyaI

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

Share this post


Link to post
Share on other sites
Steve Martino

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:

 

Share this post


Link to post
Share on other sites
TanyaI

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

Share this post


Link to post
Share on other sites
TanyaI

Worked that step out myself :) Thanks again. Great solution

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×