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

In reply to "GARYWC" who wrote the following:

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)

Use formule(A2B2)+B2-A1)

Cel set hh:mm
Use no PM/AM but 24 hours

Regards



--
--------------------------------- --- -- -
Posted with NewsLeecher v7.0 Beta 10
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -