Hi,

Put the times in A1:a4 then this formula

=24-SUM(A1:A4)

Note if the sum of the times goes over 24 this goes wrong.

Mike

"The Incredible" wrote:

Hi
i would like to add few time durations & want to substract the sum of those
from whole day time that is 24 hours.

Some thing like i would like to add
5:10
6:18
1:13
9:08

want to sum up these & want to have the difference from 24 hours.

what format, formula should i use & how to implement in the worksheet... plz
let me know.

Thanks for the help & appreciatiate the cooperation.

Sounak