I am trying to make a spread sheet that will calculate the total time that an item is used. I am using military time and have the following formula for the calculation
=TIMEVALUE(TEXT(B1,"00\:00"))-(TEXT(A1,"00\:00"))
where A1 is the start time and B1 is the end time. The times are put in as 4 digits military time (hourminute without a
. This works great until the end time(B1) is past midnight such as 0100.
Here is an example:
A1 B1 C1
1300 1530 2:30
A1 B1 C1
2300 0200 #######
Message is that it puts #### if the value is negative.
Any ideas?

=TIMEVALUE(TEXT(B1,"00\:00"))-(TEXT(A1,"00\:00"))
where A1 is the start time and B1 is the end time. The times are put in as 4 digits military time (hourminute without a

Here is an example:
A1 B1 C1
1300 1530 2:30
A1 B1 C1
2300 0200 #######
Message is that it puts #### if the value is negative.
Any ideas?
