Using Excel TIME Function with Hour, and Minute Functions to S ubtract Date and Time Read More: How to Subtract 30 Minutes from a Time in ExcelĢ. Now by dragging down or double-clicking the Fill Handle to use the AutoFill feature of Excel, we will get values in corresponding cells.Pressing the Enter key we will get the result in the E5 cell.INT(D5-C5)&" days "&TEXT(D5-C5,"h"" hrs ""m"" mins """) > Gives us the value of subtraction of total days, hours, and minutes.Įxplanation > The difference between two given dates and times. The text hours and minutes are added to the values. TEXT(D5-C5,"h"" hrs ""m"" mins """) > Converts the result of C5-D5 into hours and minutes and adds the text hrs, mins.Įxplanation: The TEXT function converts the text into hours and minutes. INT(D5-C5)&" days " > Joins 9 and the text daysĮxplanation > Concatenated part of 9 days INT(D5-C5) > Gives us the integer portion of the result of subtraction of cells C5 and D5.Įxplanation > Integer portion of ( D5-C5) (D5-C5) > Gives the value of subtraction of cells D5 and C5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |