Hi Everyone! I have a time sheet type word document with times listed. I’d like to move it to an excel sheet and have excel calculate the times for me. Does anyone know a quick way to do this? Thanks!
Example: 3/27/22: 2-10pm

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

You’ll have to finagle the structure of your data to make that process “easy”. If I had a recommended first step, I would convert the clock to 24 hours rather than 12 hour am/pm. It will make your calculation simpler.

like

Related Posts

uplifting

I'm joining Cognizant from HCL Technologies .... Do I need to transfer any PF amount? I don't have any knowledge on this? Can you help here?

like

I left my job this summer with money in my old companies FSA. I can be reimbursed only for expenses that were incurred while I was there. This was news to me. I have expenses now but not from earlier in the year because of the pandemic. Anyway - how bad would it be to just back date an invoice and submit for reimbursement? Seems like a crime with no victim.

like

In search of new employment. I have a B.S in industrial technology with a concentration in automation but I do not have many years of experience. I currently live in Mississippi open to relocating just need an opportunity

like

Anyone working in VLSI domain?

like

How can I not be awkward at conferences where all my remote coworkers that I've never met will be there? I have an issue with awkward silence and not knowing what to say or how to act.

Could someone please help me regarding this. I am really confused. It would be much helpful!Societe Generale Société Générale Quantiphi analytics pvt ltd. Quantiphi Quantiphi, Inc

Post Photo
like

Burnt out here 😭

Post Photo
likeuplifting

Merry Christmas all. Looking for good books for 2018. Possibly related towards sales. Heard about questions that sell etc. any recommendations?? Trying to learn all I can as a new RIA

like

my confession is that i hope the housing market finally crashes so i can buy and not have to sell my left nut to a seller in order to go under contract.

like

1st year SA and want to exit into finance route. For people who’ve taken this route, would you recommend another year of work experience in finance or pursuing an MBA to help with that switc?

like

Is biglaw litigation slow right now?

like

Those of you who work in Midtown and live in Brooklyn -- how do you find the commute? My firm is inching closer to return to office 3 days per week. Considering moving from downtown Manhattan to Brooklyn (Park Slope, Prospect Heights, Cobble Hill etc) for more space but have never done more than a 20 minute commute before.

like

What could be the expected package EY for fresher's (2022 B. E Graduate) ?? Any idea guys

like

Hi Fishes,

Got interviewed by JPM Chase in dec...status is you are under consideration...what's the meaning of this? am I selected for the position coz interview was on 15 dec still no reply from them.

If I am selected what should be the salary for product development associate with 2.5years of experience?I am having 3LPA now

Please any idea

How does one schmooze? I try to attend industry happy hours and networking events, but I feel super awkward when it comes to approaching and making small talk with strangers. Any tips?

like

Even if you do get followers on TikTok, they don't have much money to spend on your product or service—and they're likely not going to stick around long enough to do so anyway.

like

Has anyone here tried psilocybin to treat depression? I’ve taken zoloft for years and it worked until it didn’t. Switched to escitalopram and same thing../ I’ve read great research done using mushrooms and I’m curious, I’m done with the pills

like

I got laid off because of covid and need to discuss the severance package with my ceo tomorrow. Company offers 6 months, I want more as it probably will take much longer to find a new job.
Any tips for a conversation like this? I’m normally a strong person related to my work but feel very uncomfortable and uncertain right now. He is a good talker and I’m afraid he will walk all over me.

likefunnyhelpful

Going to talk to a CPA but curious how many of you take the home office deduction? I do most of my work at home but meet clients at an office in a high rise. The IRS info isn’t clear if I qualify

like

Additional Posts in Excel Genius

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Is there a way to wrap your header text within access database?

like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Is there a text to rows (instead of text to columns) trick?

like

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Having an Index Match problem!

I would like to multiply the values in column C, "Company X Volume" by their corresponding Price in Column F. To do this, I know I have to index match, but I'm not sure how to do that correctly given these are not exact matches.

Any ideas?

Post Photo
like

I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

like

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

I was sent an Excel skills test to complete as part of a job interview process (through Test Genius if it matters). I've had some assessments in Excel that I've bombed, and I've aced off the top of my head. I'd like to get in a quick review before taking this assessment, but I'm worried about not being prepared. Any good resources for practice, and/or tips on what topics these assessments typically cover?

like

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

like

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