# Solved: Simple excel function question

Discussion in 'Business Applications' started by DieRiding, Apr 20, 2008.

Not open for further replies.

Joined:
Oct 26, 2005
Messages:
28
Hi,

Is there a way to get excel to convert a time to a decimal? I want 6:45 to return 6.75 or 6:30 to return 6.5
If it helps, here's my situation:

I'm a waiter trying to learn excel. Thought it would be nice to use it to track my working habits and wages. I'm trying to enter tips received(C), time in(E), time out(F), and then I want to use functions to give me how many hours I worked, and what my total pay was, and my hourly.

So in (I) I've put the function =E-F to get the total hours I worked, but I can't figure out how to convert the hours to a decimal so I can use them in math functions.
Here's an example,
In at 4:30 out at 11:15. e-f returns 6:15. I want to take that and multiply it by minimum wage. but to do that I need 6:15 to be 6.25.

Thanks for any help.

2. ### maxflia10

Joined:
Feb 24, 2003
Messages:
331
Multiply by 24 and format as a number....

Joined:
Oct 26, 2005
Messages:
28
I may in fact, be retarded.

I have no idea what you mean by multiplying by 24, but it just occurred to me that I could just put the times in as decimal points in the first place and not have any problems.

Thanks for the kick in the *** to figure it out.

4. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
Open up the attachment and look at the yellow cells which are formulas.
I think this is what you want.

Excel bases time on a 24 hour clock.
This wont work if say for example you are working from 11pm to say 6 am.
However it sounds like you are working during the day and don't work more than 24 hours at a time and don't work past midnight. Is that correct?
You can input the time as 6:33 not as a fraction. The formula looks after the fraction.

I hope I have it right for you. Come back if it isn't what you want.

File size:
13.5 KB
Views:
100
5. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
Seems like we crossed maxflia10

Joined:
Oct 26, 2005
Messages:
28
That works better than what I was doing, millitary time makes more sense too. Only issue is I do work past midnight some nights. Any advice on how to handle that one?

7. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
break the time up so that you have 2 lines e.g.
23:00 24:00
00:00 8:00

8. ### maxflia10

Joined:
Feb 24, 2003
Messages:
331
For times running into the next day, try,

=MOD(B1-A1,1)*24

Where A1 is start time, B1 end time.

As Seen On