How do I separate and calculate a value in a cell with an IF

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

How do I separate and calculate a value in a cell with an IF

I am trying to calculate one cell with an hourly worked value (45), and want
to also calculate overtime from the same cell value. How do I accomplish
this? Can I use a nested IF statement or is this possible. If not do I use a
formula. I do not have a separate cell for hours worked, and a separate cell
for overtime they are included in the same cell in which I have to calculate
both scenarios.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate hours between to separate dates and times	Dave08	New Users to Excel	7	October 13th 08 10:36 AM
HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?	Cindy	Excel Worksheet Functions	1	March 2nd 06 03:29 PM
HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?	Gary L Brown	Excel Worksheet Functions	0	March 2nd 06 03:27 PM
Separate first and second name in one cell into separate cells.	Dwight in Georgia	Excel Discussion (Misc queries)	3	January 25th 06 09:09 PM
Separate first and second name in one cell into separate cells.	Gary's Student	Excel Discussion (Misc queries)	0	April 27th 05 11:11 PM

All times are GMT +1. The time now is 09:12 PM.

Menu

About Us