Calculating time

[Robert King]

I am trying to create a self calculating spreadsheet that
will take time input and then calculate the elapsed time
and add the results of several time lapses together and
render a decimal answer of total elapsed time.

Thank you

 

[Jason Morin]

MVP Chip Pearson has a nice timesheet template on his
website that you could emulate:

http://www.cpearson.com/excel/overtime.htm

HTH
Jason
Atlanta, GA

 

[Norman Harker]

Hi Robert!

With start time in A1 and end time in B1
To calculate elapsed time

=B1-A1
Returns elapsed time

To add the times and convert to decimal hours use:

=SUM(C1:C10)*24

We multiply the sum by 24 because times are recorded as a decimal of a
day.

But did you know that you can get returns of (e.g) 43:25 using:

=SUM(C1:C10)
Format > Cells > Custom Format [hh]:mm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Elvie Tan]

This is just great! It works like magic. Thanks a lot!