PPRuNe Forums - View Single Post - Formatting of hours in Excel spreadsheet
View Single Post
Old 23rd January 2007 | 00:08
  #4 (permalink)  
Keef

Official PPRuNe Chaplain
 
Joined: Apr 2001
Posts: 3,498
Likes: 0
From: Witnesham, Suffolk
You can't do it with the hours:minutes in Excel as-is.

Judicious extracting of hours and minutes, and then pasting strings together would do it.
Here's a scruffy example that shows how.

The key bit is that the numbers are formatted as text after the initial few lines.

I've assumed your hours are at least a 4-digit number or you wouldn't be bothering.

I'm sure all that lot could be wrapped up in a single formula, but I need to get some sleep
Keef is offline  
Reply