Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating hours in one cell
i am new to excel, i am trying to make a spread sheet for a weekly schedule
that will calculate the hours that will be worked for the week. for example: Name Monday Tuesday Wed Thurs Fri Sat Sun Total Jon 9 to 5 12 to 5 off 9 to 5 off off 12 to 6 27 I want the spread sheet to calculate the total hrs per day and then to add up all the days and to total it for me. Please help i am clueless. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating hours in one cell
Hi!
You need to enter the time as a TIME and use 2 cells, one for START (or IN) and one for END (or OUT): B3 = Start = 9:00 AM C3 = End = 5:00 PM D3 = Daily Total = formula: =IF(COUNT(B3:C3)<2,"",C3-B3+(C3<B3)) Format the cell as [h]:mm Returns 8:00 If a person is OFF just leave the cell empty. No real need to enter OFF. Besides, if you enter OFF you'll have to use a different formula. To get the weekly total just sum all the daily total cells: =SUM(D3,G3,J3,etc....) Also format that cell as [h]:mm Biff "CYLON" wrote in message ... i am new to excel, i am trying to make a spread sheet for a weekly schedule that will calculate the hours that will be worked for the week. for example: Name Monday Tuesday Wed Thurs Fri Sat Sun Total Jon 9 to 5 12 to 5 off 9 to 5 off off 12 to 6 27 I want the spread sheet to calculate the total hrs per day and then to add up all the days and to total it for me. Please help i am clueless. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions |