| Home > Forum Home > Automating Data Analysis Tasks > Calculating the time in Hours > RE: Calculating Time Productive | Share |
RE: Calculating Time Productive
Excel Help for Re: Calculating Time Productive in Automating Data Analysis Tasks
| Forum Topic | Login |
Re: Calculating Time Productive | Rate this: (3/5 from 1 vote) |
 | If you sheets are set up exactly this way....I also think you did not enter the correct starting times...i think you meant 2:23 and 2:24 (rather than 3:23 and 3:24) Subtract Logon from Logoff in a cell and use custom formatting of [h]:mm:ss This should give you 7:08:30. Your formula will look like: C6-C2 Now that you have the base calculation, we will add to the formula. We want to subtract areas between productive and non-productive and then subtract that from the totail spent. (C6-C2)-((C3-C2)+(C5-C4)) The end result should read as: 5:49:32 | |
| Posted by amatwrestler on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for RE: Calculating Time Productive in the Excel Business Solutions Directory |