Argh!

Hit send before I was done!

It gets really ugly....

It's not "too" ugly, but the whole idea is to make things as easy as
possible. In other words, KISS!

I would much rather use 2 cells and enter real times and use:

=(B1-A1+(B1<A1))*24

Consider this:

7-8

Is the difference 1 hour or 13 hours? That's where the problem comes into
play.

Biff

"Biff" wrote in message
...
Hi!

It gets really ugly....

It's not "too" ugly, but the whole idea is to make things as easy as
possible. In other words, KISS!

I would much rather use 2 cells and enter real times and use:


"swatsp0p" wrote
in message ...

Shorty: working hours from 7-3 is actually 8 hours!

This really won't work without convoluting his data in another formula
where (3+12)-7=8 will meet his needs.

=(right(A1,1)+12)-left(A1) and this only works for end times that are
less than the start time (3<7). try 5-12...it fails

Also, simply entering 7-3 in General format, Excel will treat as a date
7-Jul
No one ever starts at 7:30?

It gets really ugly....

I agree with Biff...use two cells and a third for calculations

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=467241