Time Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've been here before with the following question but have not been able to get my formula to work correctly.

I have a Excel based hourly time sheet: In Out In Out
Morning Lunch Evening
My first problem seems to be after12pm, my formula will not calculate if lunch is not taken at 12.

My second problem is I want to round to the 'floor' in 15 minute increments. If a time of 9:10 is entered, I want to see 9:00. I only want to see 15, 30 & 45. The formula I have now rounds to the 'nearest' 15 minute increment up & down.
The time is entered into cell a1, the rounded time is located in cell a2.
 
Second question:

=FLOOR(A1,1/24/4)

and format as time. As for the first ques., you may want
to take a look at an example time sheet on Chip Pearson's
website:

http://www.cpearson.com/excel/overtime.htm

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi, I've been here before with the following question
Click to expand...
but have not been able to get my formula to work
correctly.
I have a Excel based hourly time sheet:
Click to expand...
In Out In OutMorning Lunch Evening
My first problem seems to be after12pm, my formula will
Click to expand...
not calculate if lunch is not taken at 12.
My second problem is I want to round to the 'floor' in
Click to expand...
15 minute increments. If a time of 9:10 is entered, I
want to see 9:00. I only want to see 15, 30 & 45. The
formula I have now rounds to the 'nearest' 15 minute
increment up & down.
 
Back
Top