banner_ad

excel time difference

2059 views 7 replies

 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

 

 


Attached File : 52 time date difference.xlsx downloaded: 212 times
Replies (7)

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

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.

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

 

 

 

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

 

 

 

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,

 

Dear Sir

Please find the enclosed excel file.

Hi Rohit ...

Final Solution with total Hrs worked is here..........


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
16 May 2026
Account & Audit Asst

RAHUL KHANDEBHARAD & ASSOCIATES

Nashik

B.Com

View Details
Company
ARTICLESHIP 05 May 2026
ARTICLED ASSISTANT

JS ADVISORS

New Delhi

CA Inter

View Details
Company
12 May 2026
Accounts Executive

Nafa Group

Mumbai

B.Com

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
27 April 2026
Senior Accountant

Jyoti K agarwal & co

Mumbai

Others

View Details
Company
10 May 2026
Finance specialist

Right way solution

Ajmer

CA

View Details