View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
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.


That only works so long as the time values aren't PM start to AM End.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion