Excel Time and Date Summing from Mr Excel
 Search   Memberlist   Usergroups   Favorites   Statistics   Register

 Time and Date Summing

Michael S2004
Welcome to the Board

Joined: 20 Jan 2004
Posts: 1

Flag:

Status: Offline

Time and Date Summing

I have one columb with Date, I have a second columb with Time. mm/dd/yy and 16:22 (military time)

In the second row I have a newer Date and Time.

I would like to figure the amount of hours ( to the tenth) between the two rows.

Could you please tell me what the formula is?

Tue Jan 20, 2004 4:34 pm

firefytr
Board Master

Joined: 09 Dec 2003
Posts: 1076
Location: Boardman, OR
Flag:

Status: Offline

Re: Time and Date Summing

make sure the two date columns are formatted the same, in your formula column, take latestdate - earlierdate. format the cell to number w/ 1 decimal point.

if you want hours add * 24 in your formula cell.

hope this helps.
_________________
Regards,
Zack

Tue Jan 20, 2004 4:40 pm

BuddieB
Board Master

Joined: 06 Aug 2003
Posts: 146
Location: Boston
Flag:

Status: Offline

Re: Time and Date Summing

Simply add the date and time for each row together to combine into one date reading that XL will read.

Then you can subtract one date from the other, the resulting number is a difference in "days" which is waht Xl uses for times.

Once you have this, multiply it by 24 to get it into hours and format the cell to be #.0 to give you "tenths"

 Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows Windows 2000
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 C2A3C3C4C5 =

A
B
C
D
1
DateTimeCombined
2
1/20/200416:00:001/20/2004 16:00
3
1/22/200411:30:001/22/2004 11:30
4
Difference43.5
5
Single Formula:43.5
6

 SGH Template

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Tue Jan 20, 2004 4:46 pm
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

Forum Jump:
 Jump to: Select a forum MrExcel Forums----------------Excel QuestionsInternational forumMicrosoft AccessTechnical issues and Future development Holy Macro! Books----------------Holy Macro! Products The Lounge----------------Max Cells Lounge Announcements----------------About This BoardHall of Fame WinnersTest Here

Page 1 of 1

Forum Rules:
 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum