Posted to microsoft.public.excel.newusers

Debbie[_2_] Debbie[_2_] is offline

external usenet poster

Posts: 7

Calculating Time

I am trying to calculate the total hours attended when I type in the
hours for the day. For example: 7:30 am is in Time In and 4:00 pm is
in Time Out Column. Now I need to get the total hours, which would be
8.5 hours or 8 1/2 hours. How do I do this? Thank you in advance.

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
Calculating time and negative time	Josh UK	Excel Worksheet Functions	3	February 8th 07 04:48 PM
calculating timesheet, time-in/time-out = total hours & minutes, .	Steve Lindsay	Excel Worksheet Functions	13	November 8th 06 03:45 PM
Calculating days & time left from start date/time to end date/time	marie	Excel Worksheet Functions	7	December 7th 05 02:36 PM
Calculating Time	Paul Cooke	Excel Discussion (Misc queries)	4	December 1st 05 07:51 PM
Calculating effective time from start/end date+time	Stefan Stridh	Excel Worksheet Functions	8	November 27th 04 03:50 PM

All times are GMT +1. The time now is 08:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us