Excel Convert Datetime Stamp to HH and MM Worked

C

CeeJay4

Joined
Jan 30, 2017
Messages
5
Reaction score
1
I am working with a spreadsheet dump from an outside application, and all "time worked" columns automatically output the data in a Datetime stamp format - eg. 1/1/1900 12:52:00 AM. Somehow, in this specific cell, it is displaying 24:52:00, with a custom format of [h]:mm:ss. I am attempting to convert the datetime fields to hours and minutes worked, taking into consideration that many "hh" will be over 24. I can get there using about 14 helper fields, but there must be a better way! Please tell me there is a better way! Thanks!
 
Just so I know what you're asking... you want to change the cell format so it displays it differently?
 
Yes... I am attempting to convert the field to hours and minutes worked, taking into consideration that many "hh" will be over 24.
 
I need the output to be in a true [h]:mm format so that I can perform many more calculations on this new field.
 
If you need to use the figures for calculations, would converting the hours/minutes worked to decimal help? Just multiply by 24, and make sure that your formatting is set to number.
 
Let me give that a go. I'll touch base with you after I try it. Thank you!!
 
Ah brilliant, I'm pleased to hear that worked for you! Thanks for letting us know :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert HH:MM AM to HH:00 AM 1
Convert 23.31 into 559:26 ([hh]:mm format) 3
Excel 2007 export/import datetime 3
Remove Time from DateTime 4
time questions (roundup & convert hh to mm 1
separating date and time 5
>1 hh displays in minutes. Display in hour+? 6
Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7 10

Back
Top