Can I multiply a number and have it display in minutes?

siasarma

New Member
Joined
Sep 20, 2008
Messages
46
I am trying to multiply a normal number (1,2,3 etc...) by 20 minutes and have it display in in hours or minutes, whatever it may be. Example:
If you do not take a break at my work, you get paid an extra 20 minutes. So I want to be abel to Have a place on the timecard that goes something like this:

ColumnC Column D Column E Column F
No Break: Quantity 1 (display in hours and minutes.)

So I want to be able to change the 1 in Column E to how many breaks they didnt take and have it multiply by 20 minutes and display how much time is added to there time card in Column F.

Thanks for your help!
 

siasarma

New Member
Joined
Sep 20, 2008
Messages
46
YOUR A GENIUS!!! THANKS!!! I was so close, I just couldn't quite get it! Thank you!!!!
 

wprager

Board Regular
Joined
Jul 29, 2008
Messages
141
If the multiplier goes past 71 you'll want to format the result cell as [h]:mm, otherwise you get the 24-hour wraparound (72 * "0:20" becomes 0:00). That's a lot of missed breaks, but if you are compiling the info from multiple time sheets then it could get that high.
 

siasarma

New Member
Joined
Sep 20, 2008
Messages
46
That's great to know! I probably would have found out the hard way! Thank you!!!
 

Forum statistics

Threads
1,085,710
Messages
5,385,371
Members
401,941
Latest member
nLeo

Some videos you may like

This Week's Hot Topics

Top