Articles
FAQs
Login
All Questions
New Question
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