Evidently, as was pointed out to me off-list, I misconstrued the question, not
realizing he was referring to the results of time calculations.
Here's a solution from September:
Date: Mon, 17 Sep 2007 19:34:48 +0530
From: "Sudheer Satyanarayana" <[EMAIL PROTECTED]> Add to Address Book Add
Mobile Alert
To: [email protected]
Subject: Re: [users] Calculate time difference
Hi Dan,
That works great. You're the man.
I appreciate your help.
Dan Lewis wrote:
> On Monday September 17 2007 08:38 am, Sudheer Satyanarayana wrote:
>
>> Hi,
>>
>> I have a spreadsheet with two columns. Column A contains the start
time
>> and column B contains the end time. I enter data into these columns
in
>> the format hh:mm. In column C I would like to calculate the
difference
>> of column B and column A in minutes or hours. I'm using this
>> spreadsheet for office productivity.
>>
>> How can I achieve this?
>>
>
> Click the top of column C to highlight the entire column. Right
click
> on the "C" at the top of the column and select Format Cells from the
> context menu. This opens the Format Cells window. Make sure the
Numbers
> tab is selected. (If not click on it.) Under Category select time.
Under
> Format, select the top item: 13:37. Near the bottom you should see
HH:MM
> in the Format Code box. This will give you the difference between the
> start and finish times upto 23 hours and 59 seconds. If any of these
times
> need to be 24 hours or more, you need to modify the Format Code.
Simply
> add [] around the HH so that you have [HH]:MM. Then click the green
check
> mark at the right end of the Format Code box. Then click OK. This is
the
> formatting part.
> For the calculation: in Cell C1 enter this formula:
> = B1-A1
> and <Enter>. (Use the Enter key to enter the formula in that cell.)
Use
> the mouse to click cell C1 again. There will be a handle at the
bottom
> right corner of cell C1. (It looks like a very small square.) Move
the
> cursor over that handle, and the cursor turns to a +. While the
cursor is
> a +, drag the handle down as many rows as you want. It will add the
> correct formula to each of the cells that you have selected by
dragging
> the cursor.
>
> Dan
Rafal <[EMAIL PROTECTED]> wrote:
Hello,
I have time informations in format like "5h 3m 10s" or "4m 10s" (if zero
hours)
how to use it as a time, in example convert it into normal 4:10 format
using some regexp?
--
LimCore.com - outsourcing
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
