Newbies Long Island Posted July 25, 2007 Newbies Share Posted July 25, 2007 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted July 25, 2007 Share Posted July 25, 2007 See if this thread helps. subtracting time Link to comment Share on other sites More sharing options...
Newbies Long Island Posted July 25, 2007 Author Newbies Share Posted July 25, 2007 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted July 25, 2007 Share Posted July 25, 2007 I am not sure why you are having those results unless the data type or data itself is not correct. time_adding.zip Link to comment Share on other sites More sharing options...
Newbies Long Island Posted July 26, 2007 Author Newbies Share Posted July 26, 2007 Thank you for the example. There were several things I was doing wrong. Now it works. Thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6246 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now