Look here
http://www.cpearson.com/excel/overtime.htm
And
http://www.cpearson.com/excel/datetime.htm#AddingTimes
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Rao Ratan Singh" wrote in message
...
Dear Anybody,
pls tell me that i have how i can calculate time in seven different cells
A B C D
12.35am 11.30pm 7.00Am 7.00 pm
What will be the total Hour and minute of these