View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel Template: calc time per task fr 'start' and 'end' times

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

"LionLegal" wrote in message
...
Looking for a template to automatically calculate time spent per task via
'start' and 'end' time entries in separate cells