View Single Post
  #16   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

Am I doing something wrong? I've tried everything everyone of you have so
nicely suggested and nothing has worked.

"Benz" wrote:

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.