How do I convert hours, minutes, and seconds into decimal format?

P

Programmer Wannabe

In cell A1 I have the day, month, year, hour, minute, and second a particular
transaction took place. In cell A2 I have the day, month, year, hour, minute,
and second the next transaction takes place. The Start and End dates and
times are used to determine the total number of hours, minutes and seconds
for one transaction. I have the total number of hours, minutes, and seconds
for a given transaction in column A3. If the total time in column A3 is
greater than 12:00:00, I want to return the value of 1 Business Day in column
A4. If the total is less than 12:00:00 I want to return the total hours,
minutes, and seconds in decimal format in column A4. Is this scientifically
possible?
 
F

Fred Smith

Yes, it's possible. It depends what you mean by "hours, minutes, and seconds in
decimal format". Do you want decimal hours, minutes, seconds, or something else?

Time is stored in Excel as a fraction of a day, so 12:00:00 is 0.5 days. If you
multiply a time by 24, you will get decimal hours. So, the following should
work:

=if(a3>0.5,1,a3*24)

Format as number, or general.
 

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

Top