# help on this problem

#### Fegal

##### Board Regular
G'day all

Here is my problem,

When I enter L into B3 I want B3 to show a message.

ie B3 is blank, I enter L into B3, it the changes L to 0645 - 1515.
and it needs to be in time format so at the end of the roster i can add how many hours in total.

if that makes sense.

any help much appreciated!

Regards
james

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
i can solve the circular reference by having 2 tables. 1 as an input table and the second as the finished product. messy but it would work.
A big problem is showing the 0645 - 1515 and having excel work that out as 8.5.

is this not possible?

Excel 2010
ABCDEFGHIJKLMNO
1NAMEMon 8 AprilTue 9 AprilWed 10 AprilThu 11 AprilFri 12 AprilSat 13 AprilSun 14 April
3l
e15:15d17:00s17:30l18:30e15:15e15:15e15:15
4e15:15d17:00s17:30l18:30e15:15d17:00d17:00
5e15:15d17:00s17:30l18:30e15:15s17:30s17:30
6e15:15d17:00s17:30l18:30e15:15l18:30l18:30

</tbody>
Sheet1

ok here is what i have.
c3 e3 and g3 calculates its time from the value in the column before. somehow i need b3 d3 and f3 to = c3 e3 and g3 -8.5

Replies
16
Views
366
Replies
3
Views
431
Replies
0
Views
204
Replies
13
Views
160
Replies
5
Views
197

1,203,096
Messages
6,053,510
Members
444,669
Latest member
Renarian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back