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