Using an IF statement on time based data
Seems like you should be able to do this with an IF function, assuming
you have cells that contain a start time and an end time. For example
if the start time is in A2 and the end time is in B2, you could use
this formula
=IF(B2-A2=8/24,8,B2-A2)
.... where A2 and B2 are Excel time entries.
|