There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Business Applications
Tag Cloud
audio backup blue screen boot bsod compaq computer cpu crash dell drivers dvd error excel firefox format freeze freezing hard drive install internet internet explorer kb951748 laptop loss of internet malware memory motherboard network networking outlook outlook 2007 problem restart screen slow sound spyware startup trojan update virus vista website windows windows xp winxp wireless zone alarm zonealarm
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Excel - Time Conversion


Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
Pikeman-1270's Avatar
Junior Member with 3 posts.
 
Join Date: Jul 2008
Experience: Intermediate
11-Jul-2008, 01:41 PM #1
Solved: Excel - Time Conversion
Okay - this might be a ridiculously silly thing... but I've been working on a weekly time-card template.

I've got everything worked out except for one "minor" issue... the calculations of the total weekly hours worked - my supervisor wants to see this expressed in an HH:MM-style format.

For example: Someone has worked 38.25 hours this week... instead of displaying this as 38.25 - I would like it to be displayed as 38:15 (as in, 38-hours and 15-minutes)

Is this even possible?
AcaCandy's Avatar
Computer Specs
Administrator with 102,019 posts.
 
Join Date: Jan 2001
Location: Las Vegas, NV & Acapulco, Mexico
Experience: Advanced
11-Jul-2008, 02:19 PM #2
Hi and welcome.

You should be able to right click on the box, and go to format cells, and choose the format, I think that should be one of the options
Pikeman-1270's Avatar
Junior Member with 3 posts.
 
Join Date: Jul 2008
Experience: Intermediate
11-Jul-2008, 02:26 PM #3
- It doesn't "convert" through formatting because standard time-format is on a 12 or 24-hour clock...

Thus, anything more than 24-hours - cycles back over to 0:00 ... which means 38.25 converts to 6:15 or something like this.
The Villan's Avatar
Senior Member with 1,114 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
11-Jul-2008, 02:30 PM #4
This should do it (see attached file)

You need to select the cells that you want to format and then select Format, Cells, Custom, hh:mm

See format for cells in column C
Attached Files
File Type: xls time in hours and minutes.xls (13.5 KB, 10 views)
The Villan's Avatar
Senior Member with 1,114 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
11-Jul-2008, 02:34 PM #5
Pikeman, you are correct. My example works, but if you go over the 24 hour clock, you need to break the entries down in to day blocks.
So 00:00 to 24:00 and 00:00 to 24:00 - so basically two lines of data.
Pikeman-1270's Avatar
Junior Member with 3 posts.
 
Join Date: Jul 2008
Experience: Intermediate
11-Jul-2008, 02:41 PM #6
Okay - thanks. I figured out a way to do it (REALLY overly complicated & I think the accounting dept is just going to need to re-convert it BACK to a hourly format (38.25-hours) anyway. But ... y'know how it is... you give the boss what they want!
The Villan's Avatar
Senior Member with 1,114 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
11-Jul-2008, 04:58 PM #7
Indeed, especially if you want a salary increase :-)
AcaCandy's Avatar
Computer Specs
Administrator with 102,019 posts.
 
Join Date: Jan 2001
Location: Las Vegas, NV & Acapulco, Mexico
Experience: Advanced
11-Jul-2008, 05:32 PM #8
Quote:
Originally Posted by Pikeman-1270 View Post
Okay - thanks. I figured out a way to do it (REALLY overly complicated & I think the accounting dept is just going to need to re-convert it BACK to a hourly format (38.25-hours) anyway. But ... y'know how it is... you give the boss what they want!
True, I don't know many payroll programs that let you enter hours differently than 5.5 or 5.25 etc.......even enter actual time, it's 8:00 to 8:15..........but, the boss is always right
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 06:03 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.