Excel help needed

Alright, I have a little question for all my fellow tech enthusiasts out there... just kidding!

Does anyone know how to print filled-in Excel sheets so that both the data and the actual gridlines show up on the page? I think you know what I mean—sort of like how tables look when you print them from Word... thanks in advance!
By the way, I'm working with Microsoft Office 2003, if that makes any difference.

You could always just go ahead and add some borders to your filled-in fields if you want them to show up when you print, but if you’re really looking to get those classic Excel gridlines on the page, you can head over to Page Setup\Sheet where you'll see an option that says PrintGridlines... just check that little box and you should be all set 🙂

Frank Walker7 said:Alright, here's a question for all you hardcore tech geniuses... NOT!

How do I print out filled-in tables in Excel so that it actually shows both the data inside them AND the gridlines themselves? I think you know what I mean—like how tables look in Word... thanks.
By the way, I'm using Microsoft Office 2003, if that matters at all.

LOL...😁

Come on, give us a real challenge! If you haven't figured this one out yet, let me know so we can sit down and walk you through this massive, life-altering crisis!!!👍

But seriously, can anyone help me with this one???😢

So, basically, I need to calculate working hours. If an employee shows up at 9:00 AM and leaves at 12:15 PM, I need a formula that calculates those 3 hours and 15 minutes... or whatever the math ends up being.

I mean, I'll put the arrival time in one cell—exactly like 09:00—and then the departure time in another cell like 12:30, and I just want a third cell to automatically figure out the total time worked.

If you just set the cell format to time, you can really have it your way, whether you want things calculated by the day or just as a total sum of minutes and hours, and then you can just use the most basic math operations to work with them just like you would with any regular numbers, wouldn't that be much simpler?

William Parker7 said:LOL...😁

Could you try asking something a little more straightforward? If you haven't figured this out yet, let us know—we can sit down and walk you through that "huge" dilemma in much more detail...👍

Anyway, can someone please help me out with this???😢

So, I need to calculate work hours. If an employee clocks in at 9:00 AM and leaves at 12:15 PM, I need a formula that calculates those 3 hours and 15 minutes...

Basically, I want to enter the start time in one field as 09:00, the end time in another as 12:30, and have a third field automatically calculate the total time worked...

That's pretty easy... My advice? For anyone interested in Excel, I spent about half an hour reading a guide featured in USA Today and put together a spreadsheet for tracking bills. It’s honestly great. And no, I don't work for USA Today, so I'm not trying to sell you anything—it just really works. It covers all the basics, and for anyone looking to pick up the skill, it's perfect...

William Parker7 said:Ha.😁

Give me a simpler question. If you haven't cracked this yet, let us know—we can walk you through that critical issue in much greater detail.👍

Can someone give me a hand with this?😢

I need to calculate billable hours. If an employee clocks in at 9:00 AM and out at 12:15 PM, I need a formula that correctly calculates those 3 hours and 15 minutes.

So, I enter 09:00 in one field and 12:30 in the next, and you're telling me a third field just automatically calculates my total hours worked?

That’s how it is.
Enter your start date into the first cell—let's designate that as cell A3.
Enter the date you finished or stopped working into cell B3.
Inputting data into cell C3 equals...
Once you've entered the data, just click cell B3 once and type "-" (no quotes needed) into A3. Alternatively, select cell C3 and enter "=B3-A3" into the formula bar to achieve this result:


And just like that, you hit enter.
Just one more thing to ensure everything runs smoothly: format cell C3 as a time value. To do this, right-click on cell C3, select "Format Cells," navigate to the "Number" tab, and choose "Time." Set the format to hh:mm. For instance, you can pre-set it to 13:30.

I hope that was useful. I trust I didn't overcomplicate things.

John Kelly2 said:If you just set everything to a time format within the cell settings, you can calculate whatever you want—like total days or just a breakdown of hours and minutes—and then just use standard math operations like you would with any regular number.

Actually, I think you've got it wrong!!
I mean, I’ve picked up quite a bit about Excel over the years, but I have to admit, I still find something new every single day—it feels like I'll never truly master it because there are just endless options! It’s honestly such a great tool for anyone dealing with data at work, though, especially when you need to track specific metrics over time... it's useful everywhere, really.

I think there might be a little misunderstanding here—I'm not looking for a way to just click through the Format Cells menu and pick an option from a list...

What I'm actually trying to do is this, and I actually managed to get this part working:

http://office.microsoft.com/en-us/ex...561081050.aspx

So, let's say I have ten values in a column, and at the end, I need to sum them all up, but it just won't work. That's because the cells in that column are currently using a formula like this:
=TEXT(B2-A2;"h"). So, because of that, it won't let me sum those values in the column—unless, of course, I convert them into plain text in a different column, which is exactly what I'm trying to avoid...

Ashley Murphy19 said:So, it’s kind of like this...
- in the first cell, just put down when you actually started working—let's say that's cell A3
- then in cell B3, you'll type in when you finished or stopped for the day
- in cell C3, you're going to type =
- once you've typed the equals sign, just click once on cell B3 and type "-" (no quotes needed!) then A3, or you can just click into cell C3 and type =B3-A3 into the formula bar so it looks like this:


and then just hit enter
after that, just to be safe—I guess—format cell C3 as a time. You know, right-click on cell C3, go to Format Cells - Number tab - and pick Time. Set it to the hh:mm format, so it might show something like 13:30 by default, and just pick that.

Hopefully that helps! I really hope I didn't make it sound way too complicated or anything...

Man, I actually found another way to do it myself, and then I ran into a totally different issue—but honestly, your simple suggestion totally caught me off guard, hahaha, lol, I feel so silly now...🤣

Thanks so much for this, seriously, you're a lifesaver....👍

John Kelly2 said:Honestly, if you just set everything to a time format within the cells—you know, however you want to calculate it, whether that's by total days or just a bunch of minutes and hours—you can basically treat them like regular numbers and just use standard math operations. It’s pretty straightforward once you get the hang of it!

I mean, you weren't wrong...
man, there are just way too many options to choose from sometimes...👍

I didn't exactly lay out every single little step and detail here, but honestly, it’s all pretty much the same thing once you get moving, isn't it? You just pick out the specific range where you want to log all those timestamps, decide on whatever format looks best to you, plug in your data, and then—presto!—you just start adding or subtracting fields to get what you need...

👍