Computing formula for time

  • Thread starter Thread starter Rohit Dhamija
  • Start date Start date
R

Rohit Dhamija

I have three columns: StartTime, EndTime, TimeTaken and
the format of all three is "time"
Now i want to compute the time taken using start time and
endtime.
i.e timetaken = endtime - starttime

Can anybody tell how to add funtion for this in My sheet.
i.e on entering endtime and starttime i should get the
time taken

Rohit
 
Hi Rohit!

The following return the answer in time serial numbers representing
decimal parts of a day.

=B1-A1+(B1<A1)
OR:
=B1-A1+IF(B1<A1,1,0)
OR:
=MOD(B1-A1,1)

In all cases we can choose the time format to be displayed.

hh:mm:ss displays 09:15:00
h:mm:ss display 9:15:00
[mm]:ss display 555:00
[ss] displays 33300

To get results in decimal format:

Multiply by 24 for hours, 24*60 for minutes, and 24*60*60 for seconds.
 
Back
Top