Home |
Search |
Today's Posts |
#1
|
|||
|
|||
simple time sheet issue
Hello,
I posted a question yesterday, but i cannot find my question- or any answer, today. So here we go again- I have created a breakdown table for my companies roster. I have a simple formula in the spreadsheet that tells me how many hours of a shift was on the day rate (0530-1830) (24hr time), and how much is on the night rate (1830-0530) ( security guards). for example I need the cell that has the formula =SUM(G7-1830) (G7 being a time between 0530 and 1830), to display zero, until i type a figure into G7. Please help! P.S- I'm not fluent with Excel so laymans terms would be appreciated. thank you!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Need help with a simple Time calculation | Excel Discussion (Misc queries) | |||
Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) |