06-10-2006, 06:36
|
#22
|
Guest
Location: Near Hungerford, West Berkshire
Services: TV: Sky HD, Landline: BT,
Mobile: Orange, Internet: Quite Slow!
Posts: n/a
|
Re: Another Excel question!
Quote:
Originally Posted by Cobbydaler
Code:
=IF(A2<>0,IF((TIMEVALUE("7:30 AM")-A2)<0,0,TIMEVALUE("7:30 AM")-A2)+IF((B2-TIMEVALUE("18:30"))<0,0,B2-TIMEVALUE("18:30")),0)
Try that...
|
That changes it to 00:00 but when times are entered it brings up a load of hashes!!
My brain hurts too!!
|
|
|