99.4% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
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:
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
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
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:
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.
How to best calculate working days in relation to calculating deadlines.
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
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?
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.