41.25 minutes means 41 minutes and 15 seconds (since 15 minutes is one-quarter of a hour). right? so how would

Question

i put that in Excel, as a formula. I am making a time sheet for work. So it's telling me how many hours I'm working.
1.theres a cell that says Day
2.underneath that says the days of the week (monday, tuesday and so on) except sunday
3. next to day is start day and underneath that theres blank (thats where I put the time i get to work)
4.next to start day is Lunch start
5. and next to that is Lunch End
Then total hours.

Answer 1

I think I have a solution for you, but you'll have to use the 24 hour clock (e.g. 7:30 is 7:30 AM, 13:00 is 1:00 PM). Format all Time columns as TIME using the 24 hour clock (example is 13:30:55 in Excel 97). Format the Line Total column as NUMBER with two decimal places. You will enter your Times like so: 7:30 AM would be entered as 7:30 (7 colon 30) and 4:00 PM can be entered as 16: (16 colon). Assuming that you need a Finish column, that your Time columns are B,C,D&E and that your first line is line 3, here is the formula for your first Line Total. You can then copy it down the column. =((C3-B3)+(E3-D3))*24

Answer 2

Where is the quit time? Don't you work several hours after lunch?

Do you get paid on the hours you actually work or are you just trying to show your boss that you are working more hours than you are getting paid for?

Will you make more money if you skip lunch? Is the amount of time allotted for lunch variable?

Anyhow, you can enter times in EXCEL and subtract them and get an accurate difference. I still do not see your problem.

Answer 3

So, you want the cell to say 41.25 or you want it to say 41hours and 15 minutes?

if you want a decimal you would have to enter the hours and minutes separately, divide the minutes by 60 and add them to the hours.

Answer 4

yea i would do it that way.. i found that formatting the excel grids and trying to get excel to recognize the 60 second thing is too buggy. i would stick with converting the seconds to a scale of 100, just like you computed

Answer 5

Was it just me, or did the clock also hit 0 before Alex's touchdown pass to Vernon?