Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more question pay calcs using [h]:mm format for time worke
When I format a cell as [h]:mm to represent hours and minutes worked, say,
26:30 for 26 and 1/2 hours, it shows in cell as 26:30, but shows in the equal bar (don't know what it's called) above the spreadsheet as "1/1/1900 2:30:00AM" Why and is there a way to have that equal bar show the same as what's in the cell, i.e. 26:30? The pay calculations work fine; it's just disconcerting to click on a cell for time worked ( i.e. 26:30) and see what appears to be gibberish (i.e. 1/1/1900 2:30:00AM) in the equal bar above the spreadsheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more question pay calcs using [h]:mm format for time worke
Also, when cell is formatted as [h]:mm it appears in formula bar as time of
day, i.e. 9:30 for 9 and 1/2 hours shows as 9:30:00 AM. How do I get formula bar to show it simply as number of hours and minutes as entered in cell and not as time of day? Thanks. "Rufus" wrote: When I format a cell as [h]:mm to represent hours and minutes worked, say, 26:30 for 26 and 1/2 hours, it shows in cell as 26:30, but shows in the equal bar (don't know what it's called) above the spreadsheet as "1/1/1900 2:30:00AM" Why and is there a way to have that equal bar show the same as what's in the cell, i.e. 26:30? The pay calculations work fine; it's just disconcerting to click on a cell for time worked ( i.e. 26:30) and see what appears to be gibberish (i.e. 1/1/1900 2:30:00AM) in the equal bar above the spreadsheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more question pay calcs using [h]:mm format for time worke
in the equal bar (don't know what it's called)
It's called the formula bar. The reason it displays like that in the formula bar is because: 26:30 = 1 day + 2 hrs and 30 mins Excel is "eager" to display dates. So, it interprets 1 day + 2 hrs and 30 mins as 1/1/1900 2:30:00 AM. There is nothing you can do about that. You could hide the formula bar altogether but it's probably not what you really want to do: Goto ViewFormula bar -- Biff Microsoft Excel MVP "Rufus" wrote in message ... When I format a cell as [h]:mm to represent hours and minutes worked, say, 26:30 for 26 and 1/2 hours, it shows in cell as 26:30, but shows in the equal bar (don't know what it's called) above the spreadsheet as "1/1/1900 2:30:00AM" Why and is there a way to have that equal bar show the same as what's in the cell, i.e. 26:30? The pay calculations work fine; it's just disconcerting to click on a cell for time worked ( i.e. 26:30) and see what appears to be gibberish (i.e. 1/1/1900 2:30:00AM) in the equal bar above the spreadsheet. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more question pay calcs using [h]:mm format for time w
Thanks! I thought there might be a way to enter time simply as hours and
minutes without the hiergolyphics in the background (formula bar). Anyway, the calculations work; that's what matters I guess, not the aesthetics. File this under anal retentive or obsessive compulsive. Thanks again! "T. Valko" wrote: in the equal bar (don't know what it's called) It's called the formula bar. The reason it displays like that in the formula bar is because: 26:30 = 1 day + 2 hrs and 30 mins Excel is "eager" to display dates. So, it interprets 1 day + 2 hrs and 30 mins as 1/1/1900 2:30:00 AM. There is nothing you can do about that. You could hide the formula bar altogether but it's probably not what you really want to do: Goto ViewFormula bar -- Biff Microsoft Excel MVP "Rufus" wrote in message ... When I format a cell as [h]:mm to represent hours and minutes worked, say, 26:30 for 26 and 1/2 hours, it shows in cell as 26:30, but shows in the equal bar (don't know what it's called) above the spreadsheet as "1/1/1900 2:30:00AM" Why and is there a way to have that equal bar show the same as what's in the cell, i.e. 26:30? The pay calculations work fine; it's just disconcerting to click on a cell for time worked ( i.e. 26:30) and see what appears to be gibberish (i.e. 1/1/1900 2:30:00AM) in the equal bar above the spreadsheet. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more question pay calcs using [h]:mm format for time w
You're welcome!
-- Biff Microsoft Excel MVP "Rufus" wrote in message ... Thanks! I thought there might be a way to enter time simply as hours and minutes without the hiergolyphics in the background (formula bar). Anyway, the calculations work; that's what matters I guess, not the aesthetics. File this under anal retentive or obsessive compulsive. Thanks again! "T. Valko" wrote: in the equal bar (don't know what it's called) It's called the formula bar. The reason it displays like that in the formula bar is because: 26:30 = 1 day + 2 hrs and 30 mins Excel is "eager" to display dates. So, it interprets 1 day + 2 hrs and 30 mins as 1/1/1900 2:30:00 AM. There is nothing you can do about that. You could hide the formula bar altogether but it's probably not what you really want to do: Goto ViewFormula bar -- Biff Microsoft Excel MVP "Rufus" wrote in message ... When I format a cell as [h]:mm to represent hours and minutes worked, say, 26:30 for 26 and 1/2 hours, it shows in cell as 26:30, but shows in the equal bar (don't know what it's called) above the spreadsheet as "1/1/1900 2:30:00AM" Why and is there a way to have that equal bar show the same as what's in the cell, i.e. 26:30? The pay calculations work fine; it's just disconcerting to click on a cell for time worked ( i.e. 26:30) and see what appears to be gibberish (i.e. 1/1/1900 2:30:00AM) in the equal bar above the spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I total a long list of time calcs? | Excel Worksheet Functions | |||
Time calcs | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Time Format Question | Excel Worksheet Functions | |||
Time Calcs | Excel Worksheet Functions |