Hi All,
Not super skilled at excel, but I'm looking for a way to pull the time difference between two columns that have date/time for a process start/finish point.
The purpose would be to calculate how long the process takes.

Anyone know a method for doing so?

Posting as :
works at
You are currently posting as works at

Excel treats timestamps as numbers, so you can straight up subtract one from the other. The resulting number will be in #days, but you can multiply it by 24 to get #hours and again by 60 to get #seconds.

like

You should be able to subtract the end time from the start time and format the cell to show the result in hh:mm

like

I will help you with any excel work in exchange for an REI coupon!!

like

Related Posts

Anyone received updated offer letter yet ? for delayed joining date

When a consolidated unitary group acquires a TX Corp, does TX follow Sec. 382 and Sec. 383 and apply a limitation on the utilization of the acquired entity's TX R&D credits following the acquisition?

Waldorf Shanghai on the Bund

like

Supposed to go on an anniversary/major birthday trip this fall to Croatia/Italy. Instead looking after Christmas/NYE domestic. Ideally not frigid but not a dealbreaker. Continental US suggestions? Not FL :)

like

Planning a 2 week trip for September 2022. Thinking of doing an African safari. Any recommendations (that aren’t outrageous $$)/ know how that time of year is? 🐯🐅🦁🐘

like

Anyone have first hand experience with travel medical insurance? Looking to purchase for a short trip but finding so many mixed reviews from people that have had to actually try and use it. Appreciate any recommendations!

like

What’s the best way for me to have unlimited data/international calling when I travel to the EU this year? I usually just pay the $10/day Verizon charges me if I use my phone but data is capped or it slows down at some point if you go beyond a specific gigabyte.

likehelpful

How is the Senior Associate Role in PayTM
is it good to join?
what is the work life balance and learning?

like

Has anyone given interview in Daimler for data engineer? Can you please help what kind of questions they ask in the first round?

like

Guys anybody from Verizon have received the hike percentage for performing rating. I think this year also they won't adjust the package with market standards. ? Can anyone throw some light on this. For last 2 yrs i am receiving performing and also manager haven't initiated the mts 3 promotion. Please share a way to get a hike than getting only 10 percent

like

Am getting progressively burnt out and thinking of moving into an internal consulting role with FIs.. I have interviews with UBS and Allianz consulting lined up. Any thoughts on whether it is a good move? How’s does the work life balance and compensation fare comparatively to Big 4 consulting?

like

Anybody know how much a marriage and family counselor makes in the NY/LA area? Does it take awhile to build a clientele? Thanks in advance.

like

Is outbound customer support typically less stressful than inbound?

like

I'm starting to grow concerned that so many auditors don't seem to know the difference between the UAE and Palestine, which are entirely different countries. One of which has a large history of war with Israel. One does not. One just signed a peace agreement with Israel, but it wasn't the one stuck in a decades long war. One constantly is under threat of having land annexed by Israel, but it isn't the one in the peace agreement, and Netanyahu has already said this agreement doesn't alter plans

likehelpfulfunny

Shifted more options profits into 250 NOK shares

like

Anyone happen to be familiar with the 5300 Glencoe Park neighborhood/properties? Like it’s location to DT (job) but also want to make sure it’s good for my soon to be grade school kids.

Hi all, any recommendations on a place in Dallas I can get an assessment and also purchase running shoes at the same place.

like

Anyone have recommendations for GCs? Looking to renovate a new home in Dallas.

like

Additional Posts in Excel Genius

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Still don't have xlookup. #fomo

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

How do you fix microsoft excel cannot paste data error?

like

Would anyone be willing to teach me vlookup?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal