Microsoft Excel - REq excel formula for tome calculation

Asked By anu anu on 23-Jul-14 11:59 PM

hi all,

i have some data like below i want to know how to calculate this.

A time	C time	Ans
03-Jun-2014 01:34 PM	03-Jun-2014 01:34 PM	1:20:00

thanks
Anu

Harry Boughen replied to anu anu on 26-Jul-14 03:40 AM

Hello anu,
Simply subtract Atime from Ctime and format the Ans cell as Custom hh:mm:ss. This assumes that your Atime and CTime data are DateTime format in the first place.
Regards
Harry