View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renard Renard is offline
external usenet poster
 
Posts: 1
Default Totaling Time (Text)

How do I get a remaining balance in h:mm format. Once I get the accumulated
time, I can not get a column balance or a time remaining balance.

These are my columns
Time + Time = Time Time Time
In Out Accumulated Used
Remaining
7:oo AM 8:00 PM 8:00 4
h:mm h:mm =TEXT(C4-B4,"h:mm") Number