Discussion Locked

Calculating time in Excel

0 helpful

2 replies

by flyby9597 Jan 13, 2002 last reply Apr 21, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to create a formula that calculates time in Excel. What would be the formula to calculate from 9:30 PM to 2:15 AM with an answer of 4.75 hours?

I have tried endlessly to no availe. Thank you so much!

2 replies

by dklippert Jan 13, 2002

With
1/2/2002 9:30 AM in A1
1/3/2002 2:15 AM in A1
use = (A2-A1)*24 The result cell is formatted as a number with 2 decimals

See Chip Pearson?s site for more Date-Time tricks:

http://www.cpearson.com/excel/datearith.htm

by dklippert Apr 21, 2002

Have you solved your problem yet?

This discussion is closed to new replies.

2 replies

Trending Software posts

How Are Teams Testing AI-Generated Code Before Production?

Icons, favicons and merch graphics on Squarespace: my workflow for getting

Network Printer Works for Everyone Except Me

Can I Print Emails Directly from a PST File

Is There any Reverse Video Search Tool