View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Compute time differences

GARYWC wrote:

What formula will compute the number of hours and minutes between the Start
Time and the End time in each row?

(Each cell is formatted as number, custom, type: h:mm AM/PM)


Just "=B2-A2" and format the destination cells as time without AM/PM.

--
Kneel! Bow!