How to deduct time in excel

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Topics » How to deduct time in excel

How to deduct time in excel

In Excel dates are whole numbers and times are fractions after that.

For example, today is 39533 so at noon (12:00 PM) would be 39533.5.

There are a couple of ways to subtract 30 minutes but one of the simplest is to convert it to a fraction of a day.

Just take your number and subtract the result of 30/24*60 (or 1440). 30/1440 = 0.020833...

You can also use the TIME function (= Your Original Time - TIME(0,30,0)) but if you notice when you enter the values in the TIME function it is doing the exact maths I mentioned earlier. 30 minutes is 0.020833... days.

Related forum posts:

Excel deduct TIME

Hi, how can I deduct 2 hours from a range of times? I want all of the following times to show two hours earlier. Thanks Start time Stop time 12:43:37 0:14:41 0:14:42 2:52:42 2:52:43 4:22:37 4:22:38 4:43:30 4:43:31 6:08:10 6:08:11 8:17:43 8:17:44 8:20:15 8:20:16 8:23:41 8:23:42 8:25:23 8:25:24 8:26:25 8:26:26 8:26:58 8:26:59 8:27:57 8:27:58 8:32:24 8:32:25 11:27:18

Read forum post


Excel - time calculations

Hi there, I am trying to replicate a timesheet that we used in a previous role where the formula could calculate hours due/owed by the employee. I have managed to get the formula to work as long as the employee does their hours or over time but it will not show a negative result in the event that an employee does not do enough for that day. At present the calculation is relatively simple with a cell which adds up the finish time minus the start time and time taken for lunch (hours actual

Read forum post


Date and times in Excel

d like to understand, my helpdesk system- Supportworks (Hornbill), gives m daes through of when a call was opened and when a cll was fixed, I need to work out if a call met SLA whic is typically an 8hr fix (on-Fiday, 9 am > 5.30pm), so I need to work out a formula which will how this

Read forum post


Other posts you might be interested in:

How do I

I have to do formulas in which i need to have the expiry date but to let me know 3 months in advance from the expiry that that is due to expire.

Read forum post



How to best calculate working days in relation to calculating deadlines.

Read forum post


Excel date calculations

Hi, unfortunately i'm having a senior moment. I have 2 cells (A1 & B1), both with dates following the mm/dd/yyyy convention. Now i need to know the number of days between the 2 dates given. A simple calculation of =B1-A1 gives an answer of mm/dd/yyyy and not the number of days between those 2 dates. Any ideas? Thanks & Regards Ish

Read forum post


Date Calculations

It relates to dates calculations Start Date End Date Daily rate Monthly rate 01/12/11 31/03/12 50.00 75.00 20/12/11 20/04/12 45.00 80.00 1. Is the Start Date a full month? if not return the number of days including the start date and mulitiply by Daily rate. Example Start date 20/12/2011 means that (31days -19day = 12day * daily rate) Example: start date= 01/12/2011 mean it is a full month and should be multiplied by monthly rate. 2 Is End date a full month?

Read forum post



Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.04 secs.

✓ w3speedster