How to deduct time in excel
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

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

## 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

## 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

# 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.

## Calculations

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

## Excel date calculations

Hi, unfortunately i'm having a senior moment. I have 2 cells (A1 &amp; 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 &amp; Regards Ish

## 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?

MS Project training
 Course rating: 4.8 stars - based on 5149 reviews