Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel count concurrent events given start and end times ? | Excel Discussion (Misc queries) | |||
How can I get rid of the template task pane in Excel | New Users to Excel | |||
show time difference between start and end times | Excel Discussion (Misc queries) | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Excel 2003 Template Help Task Pane | Excel Discussion (Misc queries) |