Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default Time Calculations

Time and dates are numbers with special formatting. Since they are stored as
numbers you can treat them as such. Once you understand that, most of your
problems will go away. Think of time as portions of a day. 6:00 AM is
stored as 0.25. 6 hours is 1/4 of a day. Just remember to input time as
time (ie 30min should be entered as 00:30). If you a time output in decimal
hours (6.5 instead of 6:30) you need to multiply that cell by 24 and format
it as a number.

Example 1:
Input
A1: 0:30
A2: 0:30
A3: =A1+A2
Formatted as (using a custom number format)
A1: \.[m]
A2: \.[m]
A3: [h]
Will look like this
A1: .30
A2: .30
A3: 1

Example 2:
Input:
B1: 00:40:00
B2: 6:30:00
B3: B1+B2
Custom Number Format
B1: [m]
B2: h:mm
B3: h:mm
Will look like
B1: 40
B2: 6:30
B3: 7:10

Example 3:
Same as Example 2 except
C3: =C2-C1
Will look like
C1: 40
C2: 6:30
C3: 5:50
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Time Manipulation BFiedler Excel Discussion (Misc queries) 0 September 15th 05 01:15 AM
conditional formatting with time values Access Idiot Excel Discussion (Misc queries) 2 September 13th 05 03:29 PM
Time Calculations Paul T Excel Worksheet Functions 1 April 23rd 05 04:02 AM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM
Date and time calculations Tony Excel Discussion (Misc queries) 2 January 8th 05 05:16 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"