time based calculations

[jain_sanju]

how can i do time based calculations in excel. suppose i have written time as
05:15:00 am and i want to add 20 seconds in this time and the result should
be like 05:15:20 am.

 

[Frank Kabel]

Hi
=A1+TIME(0,0,20)

 

[Biff]

Hi!

Time entry in A1:

=A1+20/86400

Format the same as A1.

Biff