L LionLegal Dec 5, 2007 #1 Looking for a template to automatically calculate time spent per task via 'start' and 'end' time entries in separate cells
Looking for a template to automatically calculate time spent per task via 'start' and 'end' time entries in separate cells
P Pete_UK Dec 5, 2007 #2 Not sure what you mean by a template, but if you have a start time in A1 and an end time in B1, then all you need in C1 is to subtract them: C1: =B1-A1 If A1 and B1 are in Excel time format, then C1 will be too. If you want the result in hours, then modify the formula to this: =(B1-A1)*24 and format the cell as General or Number. If you want the elapsed time in minutes, multiply by a further 60. Hope this helps. Pete
Not sure what you mean by a template, but if you have a start time in A1 and an end time in B1, then all you need in C1 is to subtract them: C1: =B1-A1 If A1 and B1 are in Excel time format, then C1 will be too. If you want the result in hours, then modify the formula to this: =(B1-A1)*24 and format the cell as General or Number. If you want the elapsed time in minutes, multiply by a further 60. Hope this helps. Pete
