What’s the best way to compare lots of data with time stamps? I.e. you’re trying to evaluate the time different steps in a process take for multiple line items (10000 rows)

Current approach I’m doing is to subtract the times (in hh.mm.ss) from each other to get the duration of each step. Not sure if there’s an excel time stamp function that would make this easier. It’s not working well for times that were late PM and bleed into early next day AM.

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

You can use TIMEVALUE to convert to excel decimal values, and then substract those. And you can use TEXT to convert back to a hh:mm format. =TEXT(TIMEVALUE(A2) - TIMEVALUE(B2), ”hh:mm”)

helpful

Try converting the time stamps into Unix so then you don’t have to worry about the bleeding between two days. If you google, “convert time stamps into Unix” you will see functions you can easily copy & paste

Related Posts

What are some great investment banks to work as an associate in the Washington DC area?

like

Have to elaborate a buyers log with PE and FO in central america. Any tips on how to search this? Feel like I’m going down a rabbit hole on my google searches

like

Mercury implementation is delayed.... Wonder what is going to happen in October when it is implemented.... They won't give us off another week... Thoughts?

like

Best NY companies for healthcare PR? Looking for insights based on culture/work-life balance as well as salary.

like

Happy long weekend y’all.

Post Photo
likefunny

Anybody living in switzerland? Keen to escape the German political corona madness and looking for job opps/referrals in switzerland

like

Graduating in May and starting at a boutique commercial real estate firm mostly representing lenders. Is there any material I can start reading to help me get up to speed?

like

Heyy Fishers,

I am looking for an opportunity in the Consulting Field and keeping an open mind as I am too keen to work on projects and solve problems.

I have 8 months experience in strategic and risk role in banking and want to expand my domain knowledge of other industries

If anyone can refer me it would be greatful!!

like

Anyone from Wipro can please refer me for PM noida, it has openings and i believe i suited the profile...
Regards

like
like

Hi All, I am looking for data engineer openings for big data. I have total 5.8 years of experience and currently working in Walmart. Let me know if you have any referrals.

like

Hi Guys, currently being considered for a security developer role at Siemens Bangalore. What would be a fair compensation for my profile - BE, MSc, 1 YOE at Siemens (intern)?
Any advice is appreciated, thanks.

like

Working on the tech side of the bank, looking to transition into finance (not IB) & came across the IBI course that helps gain skills like modeling etc. Anyone taken the course/know someone who did?

like

Looking for a woman with substance behind the looks and makeup...so far, no luck.

like

Help me out - I'm starting a HedgeFund. I'm calling it ____________ Capital.

like

Soliciting ideas for a big closing lunch with clients - near or close to bryant park, my first pick was Gabriel Kreuther but they only do Thurs/Fri lunches (ours would be Tues). Ideas for upscale restaurants appropriate for corporate clients? They said “anything but steak” ha.

like

Is April month salary slip generated in FIS Global ??? Mine is not showing, when it will generate?
I doubt they didn't give me quarterly variable , I joined in mid February and even salary came less than previous month.
Did they deduct tax in April month salary of it is then fine because they didn't tax in March month .

Kindly comments if anyone have idea .

Thanks

like

Hi Fishes

I have one doubt i have 9+ year experience in Mainframe
Now i want to switch to Big Data (Doing some online course)


Is it possible to switch to big data from mainframe
Also how to say in interview rwgarding mainframe and big data


Kindly guide advise please please

like

Interning this summer in TC. Any suggestions on best pants to wear? Heard good things about lulu commission but want other opinions. Thanks in advance!

like

Hi everyone, I am working towards a career shift into management consulting, specialising in Strategy & Restructuring services to be specific. I am looking for a referral to a T2 firm within the Middle East if possible. Would love to connect, learn from your experience and take your advice on how to successfully land a role in the industry! (Currently based in Dubai)

like

Additional Posts in Excel Genius

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

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

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

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

What would you consider "Advanced" or "Expert" level Excel usage?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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

Any book recommendations on excel modeling for real world business applications?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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

How do I compare two sheets to make sure they are identical?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Would anyone be willing to teach me vlookup?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

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