PPRuNe Forums - View Single Post - Can you round up time? - Excel
View Single Post
Old 11th Jan 2005, 10:11
  #1 (permalink)  
Capt BK
 
Join Date: Dec 2001
Location: Oop north
Posts: 169
Likes: 0
Received 0 Likes on 0 Posts
Can you round up time? - Excel

Hi everyone,

I use an excel spreadsheet as a back up for my logbook (as do many it seems from the search) and was wondering if you could round up time. Eg:

using [hh]:mm = 39:55

using [hh] = 39

Is there anyway you can make it show 40?

Before anyone says dont worry about 5 minutes in your logbook, I'm not. I'm just starting to learn excel and all the different formulas possible amaze me and I wonder if there is one for this as well? I've tried using =ROUND but quite frankly I confuse easily

Of course one option is to use decimal time!

CBK
Capt BK is offline