View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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.