« previous next »
Pages: [1]

Author Topic: Excel function question  (Read 528 times)

Brad Johnson

  • friend
  • Senior Member
  • ***
  • Posts: 18,083
  • Witty, charming, handsome, and completely insane.
Excel function question
« on: March 18, 2018, 07:16:17 PM »
Hive Mind...

I'm setting up a scheduling worksheet in Excel. I'm done except for one function. I have a daily hour total derived with the formula =TIME(CELLB-CELLY, "h:mm"). I want to calculate daily total hours by taking that number less a single numerical value used to represent lunches.

I would have though it was simple as +derivedvaluecell-lunchvaluecell. Nope. There's obviously a step I'm missing to have Excel treat the daily hour total as a single number for purpose of the net daily time calc, but I can't for the life of me figure out what it is.

Thoughts?

Brad
Report to moderator   Logged
It's all about the pancakes, people.
"And he thought cops wouldn't chase... a STOLEN DONUT TRUCK???? That would be like Willie Nelson ignoring a pickup full of weed."
-HankB

Brad Johnson

  • friend
  • Senior Member
  • ***
  • Posts: 18,083
  • Witty, charming, handsome, and completely insane.
Re: Excel function question
« Reply #1 on: March 18, 2018, 07:29:35 PM »
Never mind. SWMBO figured it out. I needed to insert the lunch hour value in 0:00 format rather than as simple numeric value.

Nothing to see here. Move along please.

Brad
Report to moderator   Logged
It's all about the pancakes, people.
"And he thought cops wouldn't chase... a STOLEN DONUT TRUCK???? That would be like Willie Nelson ignoring a pickup full of weed."
-HankB

Jamisjockey

  • Booze-fueled paragon of pointless cruelty and wanton sadism
  • friend
  • Senior Member
  • ***
  • Posts: 26,580
  • Your mom sends me care packages
Re: Excel function question
« Reply #2 on: March 18, 2018, 07:34:21 PM »
You have exceltile dysfunction?
Report to moderator   Logged
JD

 The price of a lottery ticket seems to be the maximum most folks are willing to risk toward the dream of becoming a one-percenter. “Robert Hollis”

Brad Johnson

  • friend
  • Senior Member
  • ***
  • Posts: 18,083
  • Witty, charming, handsome, and completely insane.
Re: Excel function question
« Reply #3 on: March 18, 2018, 08:40:43 PM »
Premature concatination.

Brad
Report to moderator   Logged
It's all about the pancakes, people.
"And he thought cops wouldn't chase... a STOLEN DONUT TRUCK???? That would be like Willie Nelson ignoring a pickup full of weed."
-HankB

Doggy Daddy

  • Poobah
  • friend
  • Senior Member
  • ***
  • Posts: 5,333
  • From the saner side of Las Vegas
Re: Excel function question
« Reply #4 on: March 19, 2018, 08:41:28 AM »
Quote from: Brad Johnson on March 18, 2018, 07:29:35 PM
Never mind. SWMBO figured it out. I needed to insert the lunch hour value in 0:00 format rather than as simple numeric value.

Nothing to see here. Move along please.

Brad

format the time values as custom [hh]:mm.  Also, be aware that if at any point the time value goes negative, you'll get railroad tracks.
Report to moderator   Logged
Would you exchange
a walk-on part in a war
for a lead role in a cage?
-P.F.
Pages: [1]
« previous next »