Hi all,
I want to know the formula for following:
- calculate number of hours between two dates in excel
- calculate number of minutes between two dates in excel
- calculate hours and minutes in excel between two dates.
Regards,
Vikas
Hi all,
I want to know the formula for following:
- calculate number of hours between two dates in excel
- calculate number of minutes between two dates in excel
- calculate hours and minutes in excel between two dates.
Regards,
Vikas
What did you tried yourself to get the answer?
I looked at your earlier questions and it seems to me you just dump the question on the forum.
You don't show the forummembers what you tried yourself.
You don't show the forummembers you tried the search option in (e.g. this forum).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
And besides the forum, these questions are answered all over the Net
Hours: =(B1-A1)*24 format as general
Minutes: =(b1-A1)*1440 format as general
H & M: =(b1-A1) format as [h]:mm
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks