Subtracting Military Time
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Randy" wrote in message
...
All of you are awsome! Thanks for all your help.
"T. Valko" wrote:
Maybe this:
=(TEXT(B3,"00\:00")-TEXT(B2,"00\:00"))*24
--
Biff
Microsoft Excel MVP
"Randy" wrote in message
...
I have a timesheet that I enter in and out times for workers. This is
all
in
the same cell. Example: 1300-1515. In the next row i enter how many
hours
it
is. We go by 1/4 hours. So in this case I would enter 2.25. I want to
make
the in/out times in seperate rows and have the difference calculated
for
me.
When I do this, it comes out to 2.15 hours. I dont use a colon to
seperate
the time. Is there a way to calculate the difference so it shows each
1/4
hour(.25, .5, .75)? If B2 is 1300 and B3 is 1445, can a formula show
the
time
as 2.75 hours? If I can do this without using a colon, I would prefer
that.
Thanks.
|