Time Calculation

[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.

 

[Jason Morin]

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

but have not been able to get my formula to work
correctly.

I have a Excel based hourly time sheet:

In Out In OutMorning 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.