Req Excel Formula for for time calculation

[ushaanu]

hi all,

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

A timeC timeAns
03-Jun-2014 01:34 PM03-Jun-2014 01:34 PM1:20:00

Thanks
Anu

 

[Somendra Misra]

Hi Anu,

Have you posted your data correctly? I mean it's a bit confusing.

Regards,

 

[ushaanu]

HI,

Soory Correct data is below

A time B Time Answer
03/06/2014 13:45:00 03/06/2014 15:05:00 01:20:00

 

[ushaanu]

A time--- 03/06/2014 13:45:00
B time ----03/06/2014 15:05:00
Answer ----01:20:00

 

[Somendra Misra]

Isn't B1-A1 and fomating as hh:mm:ss will give you this result?

Regards,