Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel Template: calc time per task fr 'start' and 'end' times

Looking for a template to automatically calculate time spent per task via
'start' and 'end' time entries in separate cells
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can excel count concurrent events given start and end times ? Charlie B Excel Discussion (Misc queries) 4 April 21st 23 02:54 PM
How can I get rid of the template task pane in Excel Huskydog137 New Users to Excel 3 January 7th 08 04:01 PM
show time difference between start and end times erighter Excel Discussion (Misc queries) 6 July 23rd 07 10:22 PM
template or formula for start time -finish time -total hours ple cc New Users to Excel 1 March 27th 06 06:06 PM
Excel 2003 Template Help Task Pane D'Wanna Excel Discussion (Misc queries) 0 March 22nd 06 10:26 PM


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"