how to subtract hh:mm:ss.00

[plsclickme]

i am doing an elapsed time calculation which required 1/100

how do I: -

"hh:mm:ss.00" subtract "hh:mm:ss.00"

please advise... thanks in advance

[swatsp0p]

Use Custom format to set your cells as : hh:mm:ss.00

then do a simple =A2-A1 calculation to find the difference. e.g.:

A1 07:30:25.45
A2 09:35:20.30
A3 02:04:54.85

Good Luck

Bruce