Prev: select all non-blank cells from different workbook
Next: Copy and Past Values AND Formatting AND Text
From: Tacrier on 6 May 2010 13:06
Thank you David (sorry for the late reply!)

:)

"David Biddulph" wrote:

> It won't be 10.30, it will be 10:30. There is a difference between a colon
> and a decimal point.
> If you want to turn it to decimal hours, multiply by 24 and format as
> general or number instead of time.
> --
> David Biddulph
>
> Tacrier wrote:
> > I have been reading the answers to hour/minute type questions but
> > can't seem to find the answer I need...
> >
> > I am trying to calculate total hours worked in during a night shift
> > like this:
> >
> > A1 = 02/05/10 8:30 PM
> > B1 = 2/06/10 7:00 AM
> > C1 = B1-A1 = 10.30
> >
> > I would like the 10.30 to appear as 10.5 instead.
> >
> > Could anyone help me with this?
> >
> > Trina C.
> > "Pete_UK" wrote:
> >
> >> Use a custom format for the total cell:
> >>
> >> [h]:mm
> >>
> >> will stop hours above 25 being treated as days.
> >>
> >> The same can be accomplished by choosing the format "37:30:55" from
> >> the list provided under Format | Cells | Number (tab) | Time.
> >>
> >> Hope this helps.
> >>
> >> Pete
> >>
> >> Dave wrote:
> >>> Hi,
> >>> I need to add up a list of hour and minutes, the only problem being
> >>> is that Excel treats them as TIME not hours and minutes.
> >>>
> >>> For example, if I sum 7:24, 7:24 , 7:24, 7:24 [ where 7 = hours and
> >>> 24 = minutes ] then Excel five me an answer of 05:36 rather than
> >>> 29.36 - any ideas how I get this working ?
> >>>
> >>> Thanks
>
>
> .
>
 | 
Pages: 1
Prev: select all non-blank cells from different workbook
Next: Copy and Past Values AND Formatting AND Text