need Excell to display something other than what I type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kristopher Woods - 10 Oct 2007 02:06 GMT

Does anyone know how to ge excel to display something based on what I type?
Example. I want to create a schedule, and Bobby Bofinger works 12-8. next to
his name I would put ---- 12-8 ----. I would like excel to interperate this
as 8, as in 8hours. If I can get excel to recognize 12-8 as 8 hours, I can
then add all the hours for every employee. As it stands, I have to put hours
in as time, ---- 12p ----- and in a separate cell, ------ 8p ------. I just
want excell to know that if I put 12-8, it is 8 and if I put 8-5 it is 9. Is
this even possible?

Reply to this Message

Teethless mama - 10 Oct 2007 03:23 GMT

Yes, it's possible
Assuming start time in AM and end time in PM

=MID(A1,FIND("-",A1)+1,9)+12-LEFT(A1,FIND("-",A1)-1)

> Does anyone know how to ge excel to display something based on what I type?
> Example. I want to create a schedule, and Bobby Bofinger works 12-8. next to
[quoted text clipped - 4 lines]
> want excell to know that if I put 12-8, it is 8 and if I put 8-5 it is 9. Is
> this even possible?

Reply to this Message