R
Randy
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.
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.