Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 105
Default Converting Hours to Decimal

In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Converting Hours to Decimal

Helen,

Try this where C1 is the hours worked, drag down as required:-

=(C1-INT(C1))*24

Mike

"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Converting Hours to Decimal

Just use

=C1*24

and format as general or number


--
Regards,

Peo Sjoblom


"Mike H" wrote in message
...
Helen,

Try this where C1 is the hours worked, drag down as required:-

=(C1-INT(C1))*24

Mike

"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours
worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?



  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Converting Hours to Decimal

As long as the timing does not go through midnight..........

=(B1-A1)*24

Vaya con Dios,
Chuck, CABGx3





"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 105
Default Converting Hours to Decimal

Sorry; should have been more explicit.

Col A = 08:30
Col B = 15:00
Col C = SUM(a2-a1) = 6:30 = 6.5

In other words, I want to do a circular type calculation where I do the SUM
calculation followed by the c1*24 calculation, with the answer ending up in
Column C. Any chance of accomplishing that?


"Peo Sjoblom" wrote:

Just use

=C1*24

and format as general or number


--
Regards,

Peo Sjoblom


"Mike H" wrote in message
...
Helen,

Try this where C1 is the hours worked, drag down as required:-

=(C1-INT(C1))*24

Mike

"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours
worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Converting Hours to Decimal

Why are you even using SUM, B2-A2 is sufficient, so

=(B2-A2)*24

important that you change the format to general or number or else it will
display in a time format

don't know what you mean by a2-a1 since the end time is in B?


--
Regards,

Peo Sjoblom


"Helen" wrote in message
...
Sorry; should have been more explicit.

Col A = 08:30
Col B = 15:00
Col C = SUM(a2-a1) = 6:30 = 6.5

In other words, I want to do a circular type calculation where I do the
SUM
calculation followed by the c1*24 calculation, with the answer ending up
in
Column C. Any chance of accomplishing that?


"Peo Sjoblom" wrote:

Just use

=C1*24

and format as general or number


--
Regards,

Peo Sjoblom


"Mike H" wrote in message
...
Helen,

Try this where C1 is the hours worked, drag down as required:-

=(C1-INT(C1))*24

Mike

"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours
worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?






  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Converting Hours to Decimal

What equation do I use if my time goes past midnight?

"CLR" wrote:

As long as the timing does not go through midnight..........

=(B1-A1)*24

Vaya con Dios,
Chuck, CABGx3





"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 376
Default Converting Hours to Decimal

Hi Helen

Try
=MOD(B1-A1,1)*24
--
Regards
Roger Govier

ijustlivehere wrote:
What equation do I use if my time goes past midnight?

"CLR" wrote:

As long as the timing does not go through midnight..........

=(B1-A1)*24

Vaya con Dios,
Chuck, CABGx3





"Helen" wrote:

In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal.

Column A - Start Time
Column B - End Time
Column C - Hours Worked

Col A = 08:30
Col B = 15:00
Col C = 6:30 = 6.5


Is there such a formula?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to add hours and show actual hours not decimal numbers TWERNER New Users to Excel 2 August 21st 06 08:35 AM
Batch converting CSV files from comma-decimal to period-decimal Nodles Excel Discussion (Misc queries) 3 July 5th 06 06:57 PM
Converting a decimal time into hours and minutes LizHough Excel Worksheet Functions 1 July 4th 06 11:00 AM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 07:20 PM
converting a decimal number to hours and seconds jeda67 Excel Worksheet Functions 1 December 4th 05 10:35 AM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"