Time Spent

  • Thread starter Thread starter SIRSTEVE
  • Start date Start date
S

SIRSTEVE

I have a spread sheet that I have created that list start and end times in
them. Could you tell me how can I have my spreadsheet to calulate how much
time was spent in the total time spent collum.

Here's an example of what I'm talking about.
Date
User Name
Start Time
Finish Time
Total Time

I want to program it so that it will tell me the difference of time between
start and finish.

Thanks.
 
As long as start and finish don't span midnight and are formatted as "h:mm",
a simple difference will tell you the elapsed time: in the Total Time cell
enter =B4-B3 and format as h:mm. (This formula assumes the values are in
column B; adjust to suit). If the times will ever go from one calendar day
into the next, you'll have to account for that in how you enter the start and
finish values; the formula will remain the same. In my sheet in Excel 2007, I
just entered 8:42 in B3, 9:45 in B4, and =B4-B3 in B5. The answer popped in
as 1:03 with no formatting on my part.
 
Back
Top