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?
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
=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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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?
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)