pareshJ already solve my problem but if theres no value on a cell it giving me a #VALUE! error is there a way
it will show "00:00:00" if theres a VALUE error
heres the nice code by pareshj on my problem recently
"=TEXT(MID(RIGHT(A2,8),1,5)-LEFT(A2,5),"HH:MM:SS")"
Bookmarks