Jump to content
Sign in to follow this  
Long Island

Adding duration of time

Recommended Posts

I have created a time sheet and am trying to add up duration of time spent on a project and then deducting the total hours from the total project hours. I have tried defining the time fields as time,number and text and the total hours field as a calculation and summary. Nothing works. I only need hours and minutes, not seconds. Can anyone help? Thanks

Share this post


Link to post
Share on other sites

Thanks for our reply, but unfortunately this does not work. If on day 1, 1:00 (hour) is logged, day 2 :45 (minutes)and day 3 :30 (minutes), the total duration of time shoud be 2:15 (2 hours 15 minutes). Instead it adds up as 1:75. When this total is subtracted from the total project hours of 30:00, it should read 27:45 (hours/minutes left)not 28:25. Can you help?

Thanks

Share this post


Link to post
Share on other sites

I am not sure why you are having those results unless the data type or data itself is not correct.

time_adding.zip

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
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.