View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default How to find out hrs and minitus

Hi ,

I have the following data

Company working hours (l_dec_cmp_hrs) = 8.00
Staff latetime hrs (l_dec_latetime) = .10

The effective working hrs should be = 7.50 .
Please can anybody advice me with a logic to get the answer .