Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by Storza » Mon Feb 08, 2016 4:13 am
I am paid for greater 45 minutes travel time to get to a job. I can calculate the time taken to get to the job, but when I try to deduct the 45 minutes I get some very strange answers.
Can anyone suggest a formula that will help?
-
Storza
- Rookie
-
- Posts: 1
- Joined: Feb 8, 2016
- Reputation: 0
- Excel Version: windows 7
by pecoflyer » Mon Feb 08, 2016 5:51 am
Hi and welcome
if your travel time is something like 04:30 in A1, in A2 enter =A1-0.75/24 to subtract 45 min
If you have travel times shorter than 45 min you could use =MAX(0,A1-0.75/24)
A relevant topic title helps get faster and more answers
-
pecoflyer
- Moderator
-
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
Return to General Excel Questions
Who is online
Users browsing this forum: Google [Bot] and 120 guests