Hi

Excel stores times as fractions of a day hence 1 represents 24 hours
=1-SUM(A1:A4)
will give your result

Ensure the cell with the formula is formatted as time hh:mm
--
Regards
Roger Govier

"The Incredible" <The wrote in message
...
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