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

Maybe some things here will help........

http://www.cpearson.com/excel/datetime.htm#AddingTimes

Vaya con Dios,
Chuck, CABGx3




"Renard" wrote:

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