General Chat

Top tip - using the Genes Reunited community

Welcome to the Genes Reunited community boards!

  • The Genes Reunited community is made up of millions of people with similar interests. Discover your family history and make life long friends along the way.
  • You will find a close knit but welcoming group of keen genealogists all prepared to offer advice and help to new members.
  • And it's not all serious business. The boards are often a place to relax and be entertained by all kinds of subjects.
  • The Genes community will go out of their way to help you, so don’t be shy about asking for help.

Boards

Quick Search

Single word search

Tools

Findmypast DNA Banner

Icons

  • New posts
  • No new posts
  • Thread closed
  • Stickied, new posts
  • Stickied, no new posts

ANY EXPERTS IN EXCEL OUT THERE???????

Login to Add Reply Watch This
ProfilePosted byOptionsPost Date

BrianW

BrianW Report 2 Apr 2004 16:53

Click on (highlight) the cell (or line/column, etc.) you want to enter the time into. Click on Format/Cells. Number should come up as the first page. Click on Time. Choose how you want it diplayed from the Type menu on the right. Click OK. Then enter your time in the cell with colon separators.

Researching:
Sherwood (Kent); Jesson (London); Worboys (Herts)

Bob

Bob Report 2 Apr 2004 13:36

You have to format the cell as "time". Excell "sees" it aas a number which can be used in calculations. The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.). To view the time as a decimal number, select the cell and click Cells on the Format menu. Click the Number tab, and then click General or Number in the Category box. You have to enter time with a colon between the hours:mins:secs Hope this helps Bob

Gerry

Gerry Report 2 Apr 2004 13:27

I know, nowt to do with genealogy but you are all so helpful I thought I would ask. I have been trying to add hours and minutes in EXCEL but to no avail. I can't even put the time (eg 16.42) in the right format. I have tried using the relevany format (hh:mm) but it keeps reading the figs as a date and showing a spurious time!!! Very STRANGE. Anyone know acure for this malady? Gerry