After Earth (2013)
in Movies ·
Man, after watching this, even those old Steven Seagal movies actually seem kind of believable and... I don't know, maybe even watchable?!! 🙂
6 posts shown.
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!
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...
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.
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.