Posted to microsoft.public.excel.misc

jmj713

external usenet poster

Posts: 57

Difference in Time

I did a search on this topic and the solutions given for some reason don't
work for me.

I need a simple formula that will give me a difference between two times
(for instance, between 2:00 and 1:30 being 0:30).

One formula I found was =(A1-B1)*24 but it did not work. Any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Time difference calculation	Sasha	Excel Worksheet Functions	5	July 22nd 06 05:55 AM
Average Time Difference	jonhunt	Excel Worksheet Functions	4	July 13th 06 05:58 PM
Calculating time difference over midnight!	sygazelle	Excel Discussion (Misc queries)	4	September 29th 05 04:59 PM
What is the formula for getting time difference e.g. ("4 hrs 15 m.	Sandeep Manjrekar	Charts and Charting in Excel	3	December 4th 04 05:18 AM
Time / Formula to look at time difference	carl	Excel Worksheet Functions	5	November 8th 04 06:59 PM

All times are GMT +1. The time now is 04:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us