View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Benz Benz is offline
external usenet poster
 
Posts: 63
Default Enter Standard Time for H:MM Formula

To compute time spent on hourly projects, I need to know formula that will
allow me to enter standard time and have it find the difference

ie/
(Start)A1: 4:00
(End)A2: 6:48
(Total)A3: 2.8

It sounds so easy just subtract the time and divide the Minutes by 60 but I
just cant get it. Plz help! Thank You.