how to calculate hours between 2 different dates in excel
how to calculate hours between 2 different dates in excel
Welcome to the forum,
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Suppose your date in cell "A2" & "B2" (format as : dd/mm/yyyy h:mm)
For column "C" Formatting : h:mm:ss AM/PM
Formula in "C2"Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I have 4 cells , 2 with dates & 2 with time like
A2-Start Date
A3-End date
B2-Start Time
B3-End Time
Try
Formula:Please Login or Register to view this content.
It shows only hour difference but days difference is not getting picked
As was requested before in post #2 of this thread, please supply the workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try
Formula:Please Login or Register to view this content.
Screen Shot 2017-04-08 at 1.09.51 PM.png
Cant this be in C3 format i.e., hh:mm:ss format
Try
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks