Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
flexisheet problem
My spreadsheet calculates hours worked based on start/finish times. Example
start 09:00 finish 12:30 = 03:30. That's ok. I also have a cell for adjustments. if I enter 02:30, my final total will be 06:00. My problem is it won't allow me to enter a minus figure in the adjustment cell. depending how I format the cell, excel either says I can't enter it or ignores it in the calculation. Has anyone any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
flexisheet problem
The easiest way - and the most maintainable - is to use two cells for your adjustment - one for
adding, and one for subtracting. HTH, Bernie MS Excel MVP "pjk@boro" wrote in message ... My spreadsheet calculates hours worked based on start/finish times. Example start 09:00 finish 12:30 = 03:30. That's ok. I also have a cell for adjustments. if I enter 02:30, my final total will be 06:00. My problem is it won't allow me to enter a minus figure in the adjustment cell. depending how I format the cell, excel either says I can't enter it or ignores it in the calculation. Has anyone any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
flexisheet problem
Sorry, I realized that I stated my first reply poorly. Use two cells for adjustments, with the
adjustments both entered as positive values. Then use a formula that adds one and subtracts the other from your total. So if your original formula was =A2-A1 then change it to... =A2-A1+A3-A4 where A3 has the added time and A4 has the negative adjustment.... HTH, Bernie MS Excel MVP "pjk@boro" wrote in message ... My spreadsheet calculates hours worked based on start/finish times. Example start 09:00 finish 12:30 = 03:30. That's ok. I also have a cell for adjustments. if I enter 02:30, my final total will be 06:00. My problem is it won't allow me to enter a minus figure in the adjustment cell. depending how I format the cell, excel either says I can't enter it or ignores it in the calculation. Has anyone any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
flexisheet problem
Bernie,
thanks for reply but, if I try entering e.g. -2:00, I get the message "the formula you entered contains an error". Should I be formatting this cell differently? "Bernie Deitrick" wrote: The easiest way - and the most maintainable - is to use two cells for your adjustment - one for adding, and one for subtracting. HTH, Bernie MS Excel MVP "pjk@boro" wrote in message ... My spreadsheet calculates hours worked based on start/finish times. Example start 09:00 finish 12:30 = 03:30. That's ok. I also have a cell for adjustments. if I enter 02:30, my final total will be 06:00. My problem is it won't allow me to enter a minus figure in the adjustment cell. depending how I format the cell, excel either says I can't enter it or ignores it in the calculation. Has anyone any ideas? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
flexisheet problem
It's been a long week. Thanks Bernie.
"Bernie Deitrick" wrote: Sorry, I realized that I stated my first reply poorly. Use two cells for adjustments, with the adjustments both entered as positive values. Then use a formula that adds one and subtracts the other from your total. So if your original formula was =A2-A1 then change it to... =A2-A1+A3-A4 where A3 has the added time and A4 has the negative adjustment.... HTH, Bernie MS Excel MVP "pjk@boro" wrote in message ... My spreadsheet calculates hours worked based on start/finish times. Example start 09:00 finish 12:30 = 03:30. That's ok. I also have a cell for adjustments. if I enter 02:30, my final total will be 06:00. My problem is it won't allow me to enter a minus figure in the adjustment cell. depending how I format the cell, excel either says I can't enter it or ignores it in the calculation. Has anyone any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |