Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate total time between two dates
Hi
i first want to say thank you. I hope I explain myself. A1. Sunday 23:00 B1. Monday 01:00 =Sum(B1-A1) I am getting -22 hours Thank you for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate total time between two dates
Enter the date and time as below
-Press Ctrl+; (semicolon) in A1 so that excel will input the current date. Edit the date to suit -Press spacebar for a space -Press Ctrl+Shift+; (semicolon) after the space so as to input the current time. Edit the time to suit --Press Enter and you will have the date and time in excel date time format...Now you can right click the cell Format Cells and select a date format or select custom and enter a format which you would like --Once you do that in these two cells ; you can find the difference...using the below formula =B1-A1 --and custom format the formula cell to the below to display the difference in hours/ minutes [h]:mm If this post helps click Yes --------------- Jacob Skaria "Lloyd" wrote: Hi i first want to say thank you. I hope I explain myself. A1. Sunday 23:00 B1. Monday 01:00 =Sum(B1-A1) I am getting -22 hours Thank you for your help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate total time between two dates
Firstly, what number do you want to SUM to B1-A1?
If you just want =B1-A1, and don't want to SUM anything to it, you don't need the SUM function. If you don't understand what the SUM function does, look it up in Excel help. Secondly, for your problem you might want =MOD(B1-A1,1) -- David Biddulph "Lloyd" wrote in message ... Hi i first want to say thank you. I hope I explain myself. A1. Sunday 23:00 B1. Monday 01:00 =Sum(B1-A1) I am getting -22 hours Thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate from time started and finished to get total time used | Excel Worksheet Functions | |||
Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
Total Time Worked - How to Calculate | Excel Worksheet Functions | |||
calculate total service time in excel | Excel Discussion (Misc queries) | |||
i need to calculate the total time from a start time to and end t. | Excel Discussion (Misc queries) |