Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've got a daily time-tracking spreadsheet. The formula in A4 is:
=(A2<A1)+A2-A1+(A3<B2)+A3-B2 (A1 = Start Time, A2 = Lunch Begin, B2 = Lunch End, A3 = End Time, A4 = Total Hours Worked) Formatted as "[h]:mm" The formula works great, but I need the total hours to be rounded to the nearest quarter hour (.00, .25, .50, .75) Right now, if the total is 7 and a half hours, it comes out as "7.30" I've sent this question in previously and I believe the answer was to multiply the total by a number (can't remember what it was), but I needed to know how to fit that into the formula above properly and don't remember getting a response from that question. Hope that isn't too confusing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |