V
vldavis809
I have created a project that finds the difference between multipl
times and then adds up the differences. All of which is formatted i
military time and some times utilize two different days.
I would (actually the boss) would like to have the times entere
without the use of ":" and just straight "hhmm" format, to make i
easier to enter.
I changed the format to reflect hhmm, but when I enter the time i
displays in the cell as "0000" and then in the fz box as a date an
time that is nowhere close to what was entered. Then it does not d
the calculations correctly in the next cells.
If the data is already entered and I change the format to hhmm, i
works just fine, but it won't work to be able to enter it.
Any help would be appreciated, I think I am completely lost with thi
one.
See attachment for example of what is being done
+-------------------------------------------------------------------
|Filename: time example.doc
|Download: http://www.excelforum.com/attachment.php?postid=5189
+-------------------------------------------------------------------
times and then adds up the differences. All of which is formatted i
military time and some times utilize two different days.
I would (actually the boss) would like to have the times entere
without the use of ":" and just straight "hhmm" format, to make i
easier to enter.
I changed the format to reflect hhmm, but when I enter the time i
displays in the cell as "0000" and then in the fz box as a date an
time that is nowhere close to what was entered. Then it does not d
the calculations correctly in the next cells.
If the data is already entered and I change the format to hhmm, i
works just fine, but it won't work to be able to enter it.
Any help would be appreciated, I think I am completely lost with thi
one.
See attachment for example of what is being done
+-------------------------------------------------------------------
|Filename: time example.doc
|Download: http://www.excelforum.com/attachment.php?postid=5189
+-------------------------------------------------------------------