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

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

Totaling Time (Text)
 

this is really a response to Renard, but the system won't let me respond
directly to him right now??

it looks like os ratehr than 0s in time in;
did you type in the AM PM?
the c4-b4 should be 13 hours rather than 8 and you should be able to get it
with a simple subtraction. =c4-b4 with the format h:mm
I assume the time remaining should be the time accumulated - the time used
if the time used is the number of hours entered as a number
then
=time_accumulated-time_used/24
formated as h:mm


"CLR" wrote:

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