Ad-Free CAclubindia and Daily Updates on your mobile. Subscribe Now!

excel time difference

Rohit Bhalotia (CA) (52 Points)

21 September 2008

Hi Friends

I have a problem in Excel. You get idea about this problem in attached file.

This is basically relates deriving time difference in hrs for the data in a format like in attached sheet.

If you solution to this, please send solution for the attached sheet.

Thanks,

Rohit Bhalotia

Reply
Follow
Share

7 Replies

CA. Amit Daga (Finance Controller CA. CS. CFA. CIFRS. M.COM. ) (9017 Points)
Replied 21 September 2008

yar i think i am able to solve ur problem.. but ur excel sheet is not opening properly do one thing mail me at amit.daga @ in.abb.com i will try if i am able to help u

Upgrade to CAclubindia Pro. Subscribe Now!

Vishal (Make A Guess) (96 Points)
Replied 21 September 2008

Hi Rohit

Find the solution in the enclosed file

Amit the file is in Office 2007 format. Try to open with Office 2007 or Try enclosed one.

Attached File : 40 time calculation.xls downloaded: 197 times

Rohit Bhalotia (CA) (52 Points)
Replied 22 September 2008

Thanks Vivek. I have a big data in the same format as I posted here.

In solution file which you sent me, result comes in days-hrs but my need is in hrs only.

If you can make it in hrs, please send it to me.

Thanks

Rohit Bhalotia

Rohit Bhalotia (CA) (52 Points)
Replied 22 September 2008

Thanks Vivek. I have a big data in the same format as I posted here.

In solution file which you sent me, result comes in days-hrs but my need is in hrs only.

If you can make it in hrs, please send it to me.

Thanks

Rohit Bhalotia

kalpana hegde (chartered accountant) (32 Points)
Replied 22 September 2008

Hello Amit Sir,

Please answer my query, I am newly finished c.a. one of my client is want ed to open the account with bank. He is doing business of selling and producing sweets. He does not have bank account or firm name. He is doing business from his house.But now he want loan from bank .So what is the procedure to open a firm with name registration or he has to file his individual return?

Thank You,