Re: Convert time to fraction of an hour

Try this:

A1 = 12:11
B1 = 12:34

=(B1-A1)*24

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


"Patrick C. Simonds" <ordnance1@xxxxxxxxxxx> wrote in message
news:eGJRIH36HHA.4312@xxxxxxxxxxxxxxxxxxxxxxx
I have 2 time columns from which I subtract the high time from the low time
to give me the total time elapsed. So if I subtract 12:11 from 12:34 I get
:23 (or 23 minutes). What I need to be able to do is convert that :23 to
the fraction part of the hour. In this case .383


.

Relevant Pages

  • Re: Calculating sum of two given times.
    ... seems as if you want to subtract the earlier time from the later time. ... If the time will never overlap midnight, ... To show the value as a fraction, (and assuming that you will always be ... you must multiply the results of your subtraction by 24 and format the cell to ...
    (microsoft.public.excel.misc)
  • Re: How do I change an expression to display differently
    ... if you subtract one date from another, you get the number of days with time difference as a fraction. ... Access stores date/times in a numeric format where the integer portion of the number represents the date and the decimal portion of the number represents time: ...
    (microsoft.public.access.reports)
  • Re: Time Trouble
    ... Just need to subtract: ... =A2-A1 ... Format as:mm ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: Need IF/THEN formula for date present
    ... Or, for something more robust: ... Format as GENERAL or NUMBER ... Microsoft Excel MVP ... I need a formula to subtract date column 1 from date column 2 (that part I ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I Subtract 6 months off a date in excel
    ... Microsoft Excel MVP ... Just wanting to subtract 6 months off any date, and present in the format ...
    (microsoft.public.excel.misc)