These are the ways by which we can calculate the interval timings from In and Out timings which are formatted as military timings. Example. From([Stop]-[Start]), it works as long as the times are on the same day, otherwise it gives me a negative time. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. 35)Is there a single formula solution to calculating the number of hours and minutes elapsed between two dates and times? E. Over 7 minutes to 15 minutes = 1/4 hour 15. Type the other start and end times for your friends Joy and. Let’s have two dates, 6:03:59 AM and 7:05:10 AM. Since a day has 1440 (24*60) minutes, we multiply the. Please see Creating a custom time format in Excel for the detailed steps. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. To calculate total hours between start and end time, the formula in D5 is: = MOD (C5 - B5,1) This formula is explained in more detail here. 2. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. NOTE. For example, I'll try to use =AVEREAGE () on the times 1:00am and 11:00pm and it will give me 12:00pm. e start and end times). Formula is: 29:00 -23:00 results should be 6 hours. The time difference formula below always works. Find below the sample data and details for your reference. Read on to find out more. In one cell I enter the "start time", i. Now just subtract the Start Work time by using the. com to calculate time difference between two clock times. See full list on exceldemy. What I need is the above two formulas worked into one encompassing formula so that the time difference is returned regardless of the order of actual arrival time be it early, on time or late. How do I calculate this time. The average time between 1am and 11pm is 12 noon, because the measure starts from 12 midnight. How do I calculate the time duration in minutes between two times when the first time is before midnight and the second time is after midnight by considering non work hours ? For example, need to calculate the work hours in minutes between 03/17/2021 07:00PM and 03/18/2021 9:30AM the next next. ⏩ In cell E4, type the following formula. Its direction, height, illumination, and lunar phases calendar. We use sidereal time or a clock set to sidereal time to know what R. If you multiply times 24, you end up with hours. I need to return the answer both in time (custom hh:mm) and also in decimals. G2 is the only one working perfectly. There are penalty rates which apply at different times. The MOD functions does not work if you use 24 hr / military clock, as it returns 17:30 instead of 06:30 between finish and start. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? We’ll carry on with the tutorial on how to calculate hours worked after a night shift. The result in cell C1 should display the time difference as 9:00:00, indicating a. With the “Name” field selected, click Transform (tab) -> Table (group) -> Group By. Thank you for the quick reply bebo021999. In Excel I have been trying to find an easier way to calculate a time difference where the times. Here is one way: I put the target "sleep at" time in B1. g. To understand time arithmetic more fully, you need to understand first how Excel stores times. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. For example, to create a time value of 3:30 PM, you can use the formula =TIME (15, 30, 0). In column P I. select * ,datediff (second, cast ( [schedule_deptime]as time), cast ( [prev_announce_time]as time)) as kpi1_delta. 30AM to 7. Richard Buttrey. Thanks! Posted by Aladin Akyurek on July 18, 2001 9:53 AMIs there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. ) Unfortunately, Excel does not like negative times, so you’ll need to introduce an error-trapping formula. If the Start Time and End Times are on different sides of midnight (e. Consider that 10:00 pm to midnight is 2 hours, not 1 hour and 59 minutes. At sea level, water boils at 212 o F and freezes at 32 o F. Formula To Calculate Time Difference Crossing Midnight - Excel. Example:. Here's a solution that supports finding the difference even if the end time is less than the start time (over midnight interval) such as 23:55:00-00:25:00 (a half an hour duration):In the example shown, "lower" is lower bound for the period of interest, and "upper" is the upper bound. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. For each 6 hours, use 1 minute for the acceleration of time: = 1 minute. Hence, write down the below formula in the Formula Bar. Convert the Longitude to degrees. A minute is represented by an integer from 0 to 59 in the usual manner. 10pm-7. I'd like the time difference to be in minutes (but that can be done in a separate column formula). On the Celsius. 46 minutes to 60 minutes = one hour. Please see Creating a custom time format in Excel for the detailed steps. When calculating overtime pay in California, you must use the employee's "regular rate" of pay — which isn’t always simply an employee's normal hourly amount. To get the correct calculated result between two times over midnight, you can apply the following formula: 1. When a post goes over midnight, =24* (C30>D30)+D30-C30 will return 17:30 to 11:00 as 23. Dates and times are stored together (dates are day counts, stored as the integer portion of the value; times are fraction of a day, stored with the day count as a decimal fraction). Example. Please Login or Register to view this content. For that purpose, you can follow the steps below. The table above is one a I created on Power Bi desktop. Let's start with a simple formula that calculates the difference between two times in the same day. You can do it this way: select *, convert (time, convert (datetime, timeto) - convert (datetime, timefrom)) from table1. The graph has two lines, one is Blue and other one is Orange. Duration Process :6 hours. 30am, 7. Formula To Calculate Time Difference Crossing Midnight - Excel. On Wed, 19 May 2010 08:59:01 -0700, Norm wrote: I have read all the other threads on this subject and they work fine for me untill I need to cross midnight and the value is the time subtracted from 24 here are the cells: Date Store Actual Arrival Time Est Arrival Time Variance 4/6/2010 33369 11:26:00 PM 12:27:00 AM -22:59 Can someone let me know. 1. and then update the difference every second. To calculate time difference, we convert both time values to seconds since midnight using the following formula: time m = hh*3600 + mm*60. Estimating Elapsed Time in Excel Using the TODAY, NOW, NETWORKDAYS Functions. I have timestamps in column A from A5 onward. The World Clock – Current time all over the world. Start. com To calculate the number of hours between two times, you can use a formula that subtracts the start time from the end time. LinkBack. Cell H45: =J45 - J53 / 2 * H2. Solution: You have to change to the correct value. 6. The rest of the work sheet is made up of time (hh:mm) and decimals so don't really want to change the format to AM /PM. View Profile View Forum PostsTime differences between time zones are simple to work out due to the Universal Time Coordinated (UTC). A star's position is fixed in that system and it will be always at the exact same sidereal time that it culminates (as that's the definition of sidereal time). In the screenshot below, column C shows the difference between the time in consecutive rows (column. 22 actual time with seconds in place. All you need to do is to use the following formula. Over 7 minutes to 15 minutes = 1/4 hour 15. As in the example below. Calculate the Longitude in Time Units. Here, I will calculate the difference between the two times and represent that in hours, minutes, and seconds. For example lets say on April 31st I have a time of 23:30 and on May 1st I have a time of 00:22. Then you just subtract the earlier time (startMin) from the later time (endMin), and you'll get the time difference between the dates in minutes. Rows 26-34 and 49-60 do not produce wanted formatting. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. summing the times and if you format as [h]:mm:ss. 34. There are modifications available to the. Enter DateDiff ("n", [date1], [date2]) in the Field Calculator and click Ok. All you need to do is to use the following formula. 92 for 7. If you start working at 11:00 pm and finish at 7:00 am, Excel doesn't understand it's a new day. Duration Process :6 hours. To start the conversation again, simply ask a new question. As user3169 wrote, one can simply take the difference of time values (this works in Google Spreadsheets the same as in Excel). Time. Assuming that cell B1 contains start time i. How do I calculate the time duration in minutes between two times when the first time is before midnight and the second time is after midnight by considering non work hours ? For example, need to calculate the work hours in minutes between 03/17/2021 07:00PM and 03/18/2021 9:30AM the next next day by excluding non working hours (12. Calculate Total Hours Automatically Deducting Lunch Breaks - Excel. I have seen the sumproduct before and it's tried and tested, but I have yet to find a formula that does all of this AND accounts for if the start time is prior to midnight but the end time is after midnight. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. They will become Cell > Data Format > Automatic with Date and Time (Date None). Thanks, ET Formula To Calculate Time Difference Crossing Midnight - Excel. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. Full 24 examples for 2 time. 1900) and then do the calculation and in case the timeto is smaller it will get to previous day, but convert to time will get the time part from it. Standard times are shown as positive or negative deviations of UTC, that's why time differences are calculated by determining UTC and calculating each time zone from there. 45 as the difference in midnight minus 8/1/2019 1:10 PM. If you're doing hours and minutes you may have to custom format the Total (s) cell to The end times are easy to figure out:. I need to calculate two columns of time. If applicable, differences to standard times as a result of DST also. Problem With Chart When Time Spans Midnight - Excel: Hi Everybody! This is probably an easy problem, but i have never worked with this kind of data before, and in this format. 3. Subtracting 30 Minutes From Time In And Out For Schedule - Excel. Over 7 minutes to 15 minutes = 1/4 hour 15. Is there a formula that will automatically cross out a name if data is entered for that name on another sheet? In my attached workbook, I have a list of names on sheet 1 and sheet 2, once a value of any kind is entered for the name on Sheet 1 in column C I would like the matching name on sheet 2 to automatically be crossed off, is this possible?Use this calculator to add or subtract two or more time values in the form of an expression. Formula To Calculate Time Difference Crossing Midnight - Excel. These shifts can cover anything over a 24 hour period. while i am able to identify when the shift crosses midnight, i am not able to correctly calculate the total number of hours, as 00:00 is tricky, and every formula i tried for hours before midnight, when applied to hours after midnight, throws everything off, and. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. is hour 0, and the hour from noon to 1 p. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. e. To correctly calculate elapsed time I use seconds divided by 60 for minutes and milliseconds divided by 1000 for seconds. =DOLLARDE (B2/100,60)-DOLLARDE (A2/100,60) The function will return the break timing in between the pairs of times. 3. 30 minutes to 45 minutes = 3/4 hour 45. interval = millisceonds; timer1. By supplying different units, you can get the DATEDIF function to return the date difference in days, months or years. Note that if we let V 1 = 7 and V 2 = 5 we would still have a difference of 33. I have a start time and and an end time and would like to calculate the duration expended between the two. Hi all, i have a start time (from) and and end time (to) of a shift that can cross midnight. I have a spreadsheet that tracks system outages. Hello. Keeping the format as h:mm means the result corrupts once it reaches 24:00. The Problem: This is the formula I wrote to subtract these 2 ColumnsThe problem is that *your data structure is wrong*. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. Here is how Excel computes this return: (Number of days between both dates + a fraction for the difference in the number of hours). PM is used for times in the afternoon and evening. Formula: Please Login or Register to view. Step 3. Calculate Elapsed Time in Excel by Subtracting Two Date Values. 000000. Similarly, =ROUND((F2-E2)*24*60)Calendar Generator – Create a calendar for any year. Regular Rate of Pay. The online date timestamp tool will allow you to enter year, month, day, hour, minus and seconds of the start and the end date time for which you to calculate difference for. The table formula refers to those cells. In Michael's work there is a subtle but often important difference between the time 24:00 and the time 00:00, but Excel doesn't support a time of 24:00. DATEDIFF (date_part, date1, date2, [Start_of_week]) This calculation gives you more control over how date differences are computed in Tableau. or even use a parameter to dynamically change your data. 1. A. e. 33% because we are calculating a difference between two numbers and not a change from one number to another, percentage change. Thank you for the quick reply bebo021999. Start = 17:00, End = 04:00) you will need to adjust the formula to account for that. Formula To Calculate Time Difference Crossing Midnight - Excel. . I have a loan with a variable beginning balance and irregular payments. So 00:00 AM/ 12:00 PM has a value of 0 and 11:59 PM has a value of 0. IF before midnight, there is no need to add 24 hours. By using the Time Duration Calculator, one can easily find the actual time difference between two specific points in time (the starting time point and the end time point). e. I want to calculate time difference in milliseconds from current time of a day(11 am , 1 october,2012) and time at midnight for the same day (11 pm 59 m 59s , 1 october , 2012. . =MOD (B1-A1,1)*1440. The calculator below gives a time difference in years, months, days, hours, minutes, and seconds between two time points of two different Earth locations. we will say the number in cell A1 is 193. The difference of time between 11:00pm and 5:00am is -18 hours. Besides the INTCK function, we. can you update this code now I need to perform my task with system time and manual time. Figure 2. e. Enter finish time in B2. To use the TIME function, simply enter the hour, minute, and second values as arguments in the function. All three arguments are required: Start_date - the initial date of the period you want to calculate. I need to subtract the time out from the time in minus a 30 minute lunch break and be able to show if they were under 8 hours worked or over. I have 2 times that may cross midnight. If the first number is 16:51(4:51 pm) and the second is 7:52 (7:52 am the next day) I get #### for the return because Excel is seeing it as a negative number. Try this: in an empty cell, type “=NOW ()” and hit <ENTER>. " In this case both times belong to the same date and wake_time>bed_time. 8PM to 5AM for example. The above formula will give you the total number of hours elapsed between the two-time values. I need a formula to calculate Turn Around Time. having a bit of a problem with times crossing midnight. , numbers of seconds after midnight of. Looks like no one’s replied in a while. eg. The simple formula shown above doesn't work if the start time is before midnight and the end time is after midnight. Total. Ask Question Asked 3 years 11 months ago. 5 is 12 noon. Just my my 5ct advice: Use real calc date + time (datetime) as start and end values and every duration (!!!) in hours simply calculates as =A2-A1 formatted by [HH]:MM. EDIT2; Method 3 I remember how I always have to format the dates from "our" format to Excels format for it to be recognized as a date. As such, you may want a column for "total hours" to make a few simple formulae for calculating (and makes checking a bit simpler). 1. Astronomical Calculator – Moonrise and Moonset Times. 2. In cell B2 type the start time, enter a space, and then type “a” for AM or “p” for PM, and press Enter. Remember that negative time values are displayed as #####. The part of time I need = 3:30. this assumes that a shift runs no longer than 23hrs. e. Duration Process :6 hours. Following our example above, 56 hours is our base. ; Express the result as percentages by multiplying it by 100. End Time There are no problems if the outage occurs within the same date. , numbers of seconds after midnight of that same. (based on collections) Would like to enter payment and date. A. The simplest and most obvious Excel formula to calculate time difference is this: = End time - Start time. Hello, I would like to calculate times working backward from a completion time that is entered by the user. (Among the things I'll be doing is comparing those values the the corresponding values for successive mean solar days. Minute: Returns a minute value from a DateTime value. Formula To Calculate Time Difference Crossing Midnight - Excel. g. How do I get Excel to calculate the following: Start Time = 23:00 Monday Stop Time = 02:00 Tuesday. (note: 3 milliseconds is smallest granularity for time in SQL Server)Formula To Calculate Time Difference Crossing Midnight - Excel. Refinement is to use 'Date and Time' Format for start and finish, and 'Duration' format for the difference. I attempted to add one to the end time if the bike ride ends on the next day, but this approach didn't. 45 as the difference in midnight minus 8/1/2019 1:10 PM. Start Time (8:00am). TotalMilliseconds; You can use this to set a Timer: timer1. 4:00 pm. Calculate the net Profit or Loss including Commissions, not including any Open Positions: Cell H2: Enter the round-trip commission cost. The code is commented but I will also describe it here. IsTimeOfDayBetween (someTime, startTime. Re: Calculating time difference over midnight! Here is how I do it to get over the midnight as well as being able to add a meal break. You can use the equivalent formula d = rt which means distance equals rate times time. = (Start>Stop)+Stop-Start. Note that I didn't use =E24*24, I used the original values. In the case of Monday (E4<B4) evaluates to TRUE, and since TRUE = 1 it adds 1 to E4-B4 to correctly calculate the time. Re: Calculate time up to midnight. We’ll carry on with the tutorial on how to calculate hours worked after a night shift. 10pm-7. Re: formula to calculate time difference Thank Glen and Ali for your quick response . hours after midnight dont need a calculation as every day starts counting from 0 so 2 o'clock is also 2 hours after midnight only posible AM/PM notations needs to be omitted to show 1PM as 13:00 after midnight see attachment for result. If the shift begins prior to midnight but ends after midnight use a modified 24 hour clock. Add the total hours to the total minutes (in hours and minutes): 6h + 1h 30m = 7 hours and 30 minutes, or 7:30 spent gardening. "Day" hours can be calculated by 2300 minus time-in (if <2300), then "Night" hours are total hours minus "Day" hours. TimeSpan diff = d2 - d1; int millisceonds = (int) diff. In astronomy and celestial navigation, the hour angle is the dihedral angle between the meridian plane (containing Earth's axis and the zenith) and. (See the time zone converter below and the error-trapping used in the calculation. And if the value already contains a text, make sure it is valid. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. Example: End time = 1450, Start time = 1225. Start. I need to be able to work out the amount of worked time that fits into a certain time period. I would like Excel to calculate the amount of time showing full and if need be a half hour. The amount of the time span that occurred on the date is the time between the start time and midnight. G1 cross midnight, which I know is the problem,. 2. We can convert from one to the other. Format the cell containing the formula like this: Format > Number > More Formats > More date and time formats, delete "second" and :. Enter this formula: =SUM((C2-B2)+(E2-D2))*24 into a blank cell beside your time record cells, F2, for instance, see screenshot: Note: In the above formula: C2 is the lunch start time, B2 is the log in time, E2 indicates the log out time and D2 is. Now we need to indicate what value Excel should work with if. The time elapsed is 235 hours and 19 mins but is there an Excel formula to obtain this from the two values given?. Now just subtract the Start Work time by using the. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. 2011. I have a loan with a variable beginning balance and irregular payments. It's 18 hours later. Then, select Count days, hours and minutes between dates option in the. I'm having a little challenge in a simple table trying to calculate time passed for example from: 22:00 to: 2:00 in the morning. Excel will now work as follows. Heres the formula which you. Re: Calculate time up to midnight. Rename the new query “TotalTime”. The time of meridian crossings, the Moon's location on the horizon in Kilometre. All you need to do is to use the following formula. You cannot calculate in this manner to a date format field. Start Time (8:00am)Calculate hours between two times after midnight with formula. There are two approaches that you can take to present the results in the standard time format (hours : minutes : seconds). Now, Orange line is starting from time. You provide the start time, the end time, and the desired interval, and the INTCK function returns the difference in seconds, minutes, or hours. If the shift begins prior to midnight but ends after midnight use a modified 24 hour clock. Hour: Returns an hour value from a DateTime value. 30am, 7. Calculate Total Hours Automatically Deducting Lunch Breaks - Excel. This formula will help you calculate the hours difference between two times, even when the end time crosses midnight (Ex 7pm - 2am)Calculating time differences is easy, you can simply subtract an earlier time from a later one 1. (based on collections) Would like to enter payment and date. Duration Process :6 hours. End Date 4. e. __________________________. Month, today. 46 minutes to 60 minutes = one hour. Here is the way the previous poster described it: "Excel template: Loan Amortization for random/irregular payments, figures days. The formula in previous post is only available for Excel 365/2021 users This formula is available for all Excel-users. e. You have to account for crossing midnight. The MOD (. Start. . Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. 6. They work on shifts and the operation is 24 hours. Write down the times on a sheet of paper using the local times for the airport. =IF ( (end-start)<0, (end-start)*24+24, (end-start)*24) If you want to see hours and minutes you'd need to modify it to pick. If Function In Time Range - Excel. Formula To Calculate Time Difference Crossing Midnight - Excel. " In this case both times belong to the same date and wake_time>bed_time. If the value in C7 is greater than the value in D7 the value in D7 is from the next day. I want to calculate the number of hours done within 8am till 18:30pm and 18:30pm to 8am. Start. For example,. The fourth column is a simple subtraction formula taking column three from column two. IF after midnight, 24 hours are added to the finish time to allow the calculation of Finish time minus Start Time to still work. = (HOUR (B2)-HOUR (A2)+DAYS (B2,A2)*24)*60 + MINUTE (B2)-MINUTE (A2) where A2 is the start datetime, and B2 is the end datetime. Re: Calculating elapsed time when time crosses over midnight. A good thing to remember is that times are always a fraction of 1. To apply the custom time format, click Ctrl + 1 to open the Format Cells dialog, select Custom from the Category list and type the time codes in the Type box. Formula To Calculate Time Difference Crossing Midnight - Excel. Google Spreadsheets doesn't seem to. Similarly I like to do those like this. For total shift time = (1-C2)+D2. Browse; Search; Sign in From the hour mark to 6 minutes = 0 time paid. I am a little confused with what you are after when you are stipulating. Here is the. . The formula for calculating the Local Time equivalent for Local Solar Time is LST = LT + TC 60 L S T = L T + T C 60, where TC T C is the Time Correction factor TC = 4(Longitude − LSTM) + EoT T C = 4 ( L o n g i t u d e − L S T M) + E o T. Select Format Cells and in Number tab choose Time format. This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. 1. 4: Aug 25, 2007: Countifs with different restrictions: 1: Nov 29, 2012: Averaging Duration of Time: Duration Longer than 24hr: 2: Apr 10, 2008: Convert times to text string: 3: Apr 21, 2010 [NEWBIE] date/time diff: 4: Jun 25, 2009: formula to calculate time difference crossing midnight: 3: Aug 17. My issue is with the first row. . Calculating time difference when times are cross midnight. then subtract the earlier time. In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. The rest of the work sheet is made up of time (hh:mm) and decimals so don't really want to change the format to AM /PM. Formula To Calculate Time Difference Crossing Midnight - Excel. Type in the comma and we’ll move on. formula to calculate time difference crossing midnight. In this video, you will see the easiest way to find the time difference between two dates and times that go past midnight. To show a time interval of more than 24 hours, 60 minutes, or 60 seconds, apply a custom time format where a corresponding time unit code is enclosed in square brackets, like [h], [m], or [s]. Same as minutes we can also get the difference in seconds. we figure the bowler's average and subtract it from 200. For example, let’s say your start time is 8:05 AM, and your end time is 12:15 PM. Most entries fall within the same day's 24 hour limit, so a simple forumla "=b1-a1" will do. First of all, you can calculate the difference between two times by direct substitution. 2. Depending on you data structure, the actual time difference formula may take various shapes, for example: Formula. The LST zones show how the local time beneath the satellite varies at different latitudes and different points on its orbit. Use formula: = (E1+J1)- (C1+I1) we just add the date and time together and subtract the end from start and then format the cell having the formula to show days, hours, minutes. Enter this formula: =(B2-A2+(B2<A2))*24 (A2 is the earlier time, B2 is the later time, you can change them as you need) into a blank cell which beside your time data, see. Here, I will apply the INT function to calculate the time difference. Start Time 3. After the ‘if’ word, we’ll start typing out the condition itself – the ‘Start Work’ time (the value in cell C7) is greater than the ‘End Work’ time (the value in cell D7), which is true for the working time that spans midnight. The Time Duration Calculator will calculate the time that has elapsed/difference between. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? If I calculate TAT for this time period it should show me 1 hour 33 minutes, why because business hours are closing by 5:00 PM on 10/29 so it should not calculate duration after 5:00 PM to until 08:00 AM on next day, however 10/29 is Friday so formula should calculate the duration from 10/29 Friday 3:37 PM to 10/29 5:00 PM and again it should. They work on shifts and the operation is 24 hours. ; Find the average of those two numbers: (a + b) / 2. It is used worldwide to avoid confusion arising from local time differences. In Excel I have been trying to find an easier way to calculate a time difference where the times. Start Time (8:00am). Duration Process :6 hours. Follow. Start time in A1, end time in B1 =B1-A1+(B1<A1) (format result as time) or =MOD(B1-A1,1) will return 6:00 with 09:00 PM in A1 and 03:00 AM in B1-- Regards, Peo Sjoblom "mailrail" wrote in message. Simple duration calculation When start time and end time occur in the same day, calculating duration in hours is straightforward.