View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
helen helen is offline
external usenet poster
 
Posts: 105
Default Formula to calculate time

I have the hours worked in Column A (i.e., 8:00 - 5:00) and the total hours
in Column B (8.0). Is there a formula for Column B that will calculate that
for me, or will I have to use two columns for the hours worked (start time
and end time) AND use military time in order to do a simple math function
formula?

Thanks for your help!