Totaling Time (Text)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top