05-10-2006, 17:11
|
#10
|
Inactive
Join Date: Jun 2006
Location: Cambridge
Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died).
Posts: 4,349
|
Re: Another Excel question!
Quote:
Originally Posted by lsainsbury
Hmmm...
=IF((TIMEVALUE("7:30 AM")-E10)<0,0,TIMEVALUE("7:30 AM")-E10)+IF((F10-TIMEVALUE("18:30"))<0,0,F10-TIMEVALUE("18:30"))
07:30 - 19:30
Result = 0.04
Should be 1
|
Have you formatted the cells as hh:mm? 0.04 of a day is 1 hour.
Quote:
Originally Posted by Cobbydaler
Attached any good? Gives you the facility to change the start & end qualifying times if you need to...
|
Very good!
|
|
|