Posted to microsoft.public.excel.worksheet.functions

David Biddulph[_2_] David Biddulph[_2_] is offline

external usenet poster

Posts: 8,651

calculate hours

=(A2-A1)*24 and format as General or Number, if you want the answer in
decimal hours.
--
David Biddulph

"gma" wrote in message
...
how do you calculate hours i.e.
3:45am-11:15am = ______hrs?

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
calculate hours.	Maria Teresa	Excel Discussion (Misc queries)	3	May 29th 09 04:40 PM
How do you calculate hours?	chefd	Excel Discussion (Misc queries)	2	February 29th 08 10:03 PM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis	Graham	Excel Discussion (Misc queries)	2	January 28th 07 08:40 PM
calculate hours	Caveman	Excel Discussion (Misc queries)	1	May 29th 06 11:52 PM
How to calculate hours?	cheryl	Excel Worksheet Functions	6	August 2nd 05 08:20 AM

All times are GMT +1. The time now is 12:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us